Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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