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: 
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 - Specialist III
Partner - Specialist III

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 - Specialist III
Partner - Specialist III

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 - Specialist III
Partner - Specialist III

Glad it worked .