Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
prasadmundewadi
Contributor III
Contributor III

Set analysis help comparing 2 fields

I have following set analysis which is working as expected for some records and for others it is not working. Can somebody help?

sum({<[Snapshot Quarter]-={$(=Current Snapshot Quarter)}>}[Amount])

I want to sum Amount for all records which have snapshot quarter not equal to current snapshot quarter.

Here 'Snapshot Quarter' is available in a Date dim table. and 'Current Snapshot Quarter' is available on fact table.

Is my set analysis statement correct? (i think it is because it works for many records)

1 Solution

Accepted Solutions
felipedl
Partner
Partner

Hi Prasad,

try using quotes inside the set analysis

sum({<[Snapshot Quarter]-={"$(=Current Snapshot Quarter)"}>}[Amount])


Felipe.

View solution in original post

3 Replies
felipedl
Partner
Partner

Hi Prasad,

try using quotes inside the set analysis

sum({<[Snapshot Quarter]-={"$(=Current Snapshot Quarter)"}>}[Amount])


Felipe.

prasadmundewadi
Contributor III
Contributor III
Author

Thank you that worked

felipedl
Partner
Partner

Glad it worked .