topic Set Analysis with selected values in QlikView

Set Analysis with selected values

qlikviewaf — Mon, 27 Nov 2017 15:27:24 GMT

HI,

i'm using this set analysis.

Basically i would like to select Month and Year, and then have a graph showing Month and Year based on other fields (Month_Surgery and Year Surgery)

=Sum({<Invoice_Date_Num=,Month_Surgery={$(=Concat(Chr(39) & GetFieldSelections(Month) & Chr(39), ','))}, Day=,Year=,Month=,Year_Surgery={$(=Concat(Chr(39) & GetFieldSelections(Year) & Chr(39), ','))}>}WI_EUR)

This formula is working only if 1 month is selected - i would like to have graph also if more than one month is selected.

How i can do this?

Thanks!

Re: Set Analysis with selected values

YoussefBelloum — Mon, 27 Nov 2017 15:29:20 GMT

Hi,

can you attach your app ? or sample data from the data you have ?

Re: Set Analysis with selected values

avkeep01 — Mon, 27 Nov 2017 15:32:44 GMT

Hi Antonio,

You could use the following expression. I assumed that Date_Surgery is also an available field.

=Sum({<Invoice_Date_Num=,Month_Surgery=,Date_Surgery={">=$(=MIN(Date_Surgery)) <=$(=MAX(Date_Surgery))"}, Day=,Year=,Month=,Year_Surgery={">=$(=MIN(Year_Surgery)) <=$(=MAX(Year_Surgery))"}>}WI_EUR)

Another option is to put the red part in your expression in a variable. And then experiment wether you should use

- Month_Surgery={$(vMonths)}

- Month_Surgery={"$(vMonths)"}

- Month_Surgery={$(=vMonths)}

- Month_Surgery={"=$(vMonths)"}

- Month_Surgery={"=$(=vMonths)"}

Re: Set Analysis with selected values

qlikviewaf — Mon, 27 Nov 2017 15:47:20 GMT

Find attached the app, if i select more than 1 month - no data are displayed.

E.g. selecting just YEAR 2016 and MONTH June, works.

Please help! Thank you!!

Re: Set Analysis with selected values

qlikviewaf — Mon, 27 Nov 2017 15:48:08 GMT

I tried withous success!!

can you please help? I attached the app! !

Re: Set Analysis with selected values

avkeep01 — Mon, 27 Nov 2017 15:50:12 GMT

The variable part seems to be working. App is attached.

Re: Set Analysis with selected values

YoussefBelloum — Mon, 27 Nov 2017 16:06:55 GMT

attached the app, try and tell me

Re: Set Analysis with selected values

qlikviewaf — Mon, 27 Nov 2017 16:41:47 GMT

magic! working properly!

Thank you All!