Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
tripatiqv
Partner - Contributor III
Partner - Contributor III

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 - Contributor III
Partner - Contributor III

Hi,

 

 

Please share the sample data or qvw.

 

Thanks and Regards

Nikks