Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dotnetfan
Contributor III
Contributor III

Expression in pivot table

Hello,

I have a dataset with three dimensions , 

Category,DateKey,Value

A,              201901, 123

A,              201902,345

... ...

A,              201912,789

B,              201901,234

B,              201902,567

... ...

B,              201912,789

So I use pivot table to display two dimensions and value. User want to have a new requirement, they want a variable to store as start DateKey and they can change it manually. If user type in 201904, then the value from 201901 to 201903 will apply for another logic and I want to check the current column whether equals to the type in value, 

Variable name: CurrentMonth

If("=Right(LT.Month,2)-$(=CurrentMonth)" = 0, xxx,xxx) but it doesn't work. 

Can you please help me to fix it?

 

0 Replies