Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

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
MVP
MVP

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
MVP
MVP

No problem