Tuesday, July 10, 2012

QlikView : Add Calculation Expression in Chart

1. We can use this expression any ware.

2.You can rectify this "Error in calculated dimension" problem.

 Example : 1
=if(len(GetCurrentSelections(PH_Month))=0 AND len(GetCurrentSelections(PH_Year))=0,PH_Date1,PH_Date)

Example : 2
=if(len(GetCurrentSelections(PH_Month))=0 AND len(GetCurrentSelections(PH_Year))=0,num(SUM(PH_NoofHits2), '#,###,###,#00'),num(SUM(PH_NoofHits), '#,###,###,#00'))

No comments:

Post a Comment