Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shah_jigesh16
Partner - Contributor III
Partner - Contributor III

Reference Dimension Value in an expression

     Hi All,

Working on a scenario where would like to reference the dimension value in the expression.

For Example:

1.Year 1 is Pulled as a dimension in Pivot Table

2.Year 2 is used in expression.

3.Year2 should be compared to Year 1 value in an expression to calculate the sum of AMOUNT.

Worked on Multiple options and looked into multiple COntent on the community but wasn't able to achieve anything.

Expected Something like below.

Sum({<Year2=Year1>} Amount)

Was anyone able to achieve this?

Help required.

Thanks,

JD

1 Reply
trdandamudi
Master II
Master II

How about :

Sum(IF(Year2=Year1,Amount,0))