Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

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
Highlighted

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

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
Highlighted

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

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

Highlighted
New Contributor III

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

Hi Sonu,

Thank you so much for your reply.

It's working correctly

-Poonam

Highlighted

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

No problem