Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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