Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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