Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
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 .