Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tripatiqv
Partner
Partner

Need help in qlikview function

Hi,

I have one pivot table  that is having 36 expression 3 expression for each month. the expression are current year, previous year , %overLY, ,the pivot table is working with variable vReportmonth

if the variable vReportmonth value is 1, then 3  expression for JAN MONTH(current year, previous year , %overLY)  calculating  and similarly vReportmonth value is 2, then 3  expression for FEB MONTH(current year, previous year , %overLY)  calculating  and so on.

Now my requirement  is instead of writing 36 expression i need 3 expression. I dont want to use variable vreportmonth in enabling the expression.

 

 

2 Replies
Rek
Contributor
Contributor

Hello,

You should use the month in dimension.

Concerning the variable, is it an input value ? or defined in script ? and why you want get ride of it ? 

//Rek 

nilaksh92
Partner
Partner

Hi,

 

 

Please share the sample data or qvw.

 

Thanks and Regards

Nikks