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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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