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: 
Anonymous
Not applicable

Set analysis - Ignore All fields selection excluding Month, Year field

Hi ,

I am trying to apply set analysis for Summary view. The values should not change based on any selection except Year, Month selection.

Is there any way for this?

I found one solution --> sum({<month =, year=, day=>}fieldname)

But the application is having many fields so is there any other way?

Thanks in advance

Regards,

Poonam Patil

1 Solution

Accepted Solutions
sunny_talwar

Try this:

{1<month = $::month, year = $::year, day = $::day>}

EDIT: Are you looking for the expression to change only on selection in month, year and day field? or are you wanting the expression to change to all selections except a selection in month, year, day?

View solution in original post

3 Replies
sunny_talwar

Try this:

{1<month = $::month, year = $::year, day = $::day>}

EDIT: Are you looking for the expression to change only on selection in month, year and day field? or are you wanting the expression to change to all selections except a selection in month, year, day?

Anonymous
Not applicable
Author

Hi Sonu,

Thank you so much for your reply.

It's working correctly

-Poonam

sunny_talwar

No problem