Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

prasadmundewadi
New 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
Valued Contributor III

Re: Set analysis help comparing 2 fields

Hi Prasad,

try using quotes inside the set analysis

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


Felipe.

3 Replies
felipedl
Valued Contributor III

Re: Set analysis help comparing 2 fields

Hi Prasad,

try using quotes inside the set analysis

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


Felipe.

prasadmundewadi
New Contributor III

Re: Set analysis help comparing 2 fields

Thank you that worked

felipedl
Valued Contributor III

Re: Set analysis help comparing 2 fields

Glad it worked .