Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qlikviewaf
New Contributor III

Set Analysis with selected values

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!


issueeeeeeejasodfdsa.png

1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

Re: Set Analysis with selected values

attached the app, try and tell me

7 Replies
YoussefBelloum
Esteemed Contributor

Re: Set Analysis with selected values

Hi,

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

avkeep01
Valued Contributor

Re: Set Analysis with selected values

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)"}

qlikviewaf
New Contributor III

Re: Set Analysis with selected values

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

qlikviewaf
New Contributor III

Re: Set Analysis with selected values

I tried withous success!!

can you please help? I attached the app! !

avkeep01
Valued Contributor

Re: Set Analysis with selected values

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

YoussefBelloum
Esteemed Contributor

Re: Set Analysis with selected values

attached the app, try and tell me

qlikviewaf
New Contributor III

Re: Set Analysis with selected values

magic! working properly!

Thank you All!

Community Browser