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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adhoc Reports - How to use set analysis in Expression

Hi All ,

I have a scenario in which the following set Analysis has to be used in Adhoc Reporting

Sum({$<YEAR = {$(=Max(YEAR)-1)}>} VOLUME)

I have 2 Table : Dimension , Measures

Dimensions are

CHANNEL

REGION

COUNTRY

Measures are

YTDN-1

etc

How can i add the above set analysis in a way that it works in Expression for Adhoc Reporting?

Thanks

Labels (1)
0 Replies