Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewaf
Creator
Creator

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

attached the app, try and tell me

View solution in original post

7 Replies
YoussefBelloum
Champion
Champion

Hi,

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

avkeep01
Partner - Specialist
Partner - Specialist

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
Creator
Creator
Author

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
Creator
Creator
Author

I tried withous success!!

can you please help? I attached the app! !

avkeep01
Partner - Specialist
Partner - Specialist

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

YoussefBelloum
Champion
Champion

attached the app, try and tell me

qlikviewaf
Creator
Creator
Author

magic! working properly!

Thank you All!