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

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

Anonymous — Wed, 23 Dec 2015 07:13:50 GMT

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

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

sunny_talwar — Wed, 23 Dec 2015 16:23:19 GMT

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?

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

Anonymous — Mon, 28 Dec 2015 10:31:58 GMT

Hi Sonu,

Thank you so much for your reply.

It's working correctly

-Poonam

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

sunny_talwar — Mon, 28 Dec 2015 10:37:21 GMT

No problem