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: 
Not applicable

If statement combined with set analysis

Hi everyone!

Im new to qlik sense and having problems with combining set analysis with an if statement. I am making a line chart and only want the last twelve months to be shown, but I also want a filter on a dimension. Its when Im adding the if statement that it stops working.

CustomerGroup=Numeric dimension

Indicator=Sum(NBCustomer)

if(CustomerGroup=1, Sum({$<Month=, Year=, Date={">=$(=MonthStart(AddMonths(Max(Date),-12)))<$(=MonthEnd(Max(Date)))"}>} [NbCustomer]))

This part works seperatly:

Sum({$<Month=, Year=, Date={">=$(=MonthStart(AddMonths(Max(Date),-12)))<$(=MonthEnd(Max(Date)))"}>} [NbCustomer])


Please help!!


Kind regards,

Sofia

1 Solution

Accepted Solutions
Ivan_Bozov
Luminary
Luminary

Try this for your expression:

Sum({$<CustomerGroup={'1'}, Month=, Year=, Date={">=$(=MonthStart(AddMonths(Max(Date),-12)))<$(=MonthEnd(Max(Date)))"}>} [NbCustomer])

vizmind.eu

View solution in original post

8 Replies
agigliotti
Partner - Champion
Partner - Champion

please tell us which dimensions and measures you are using in line chart.

Not applicable
Author

Hello!

CustomerGroup=Numeric dimension

Indicator=Sum(NBCustomer)

Date=date dimension

agigliotti
Partner - Champion
Partner - Champion

why you need to use IF ?

Not applicable
Author

I probably dont! If you have a better way I would very much appreciate it!

Kind regards,

Sofia

Ivan_Bozov
Luminary
Luminary

Try this for your expression:

Sum({$<CustomerGroup={'1'}, Month=, Year=, Date={">=$(=MonthStart(AddMonths(Max(Date),-12)))<$(=MonthEnd(Max(Date)))"}>} [NbCustomer])

vizmind.eu
Clever_Anjos
Employee
Employee

Please try this:

Sum({$<CustomerGroup*={"1"},Month=, Year=, Date={">=$(=MonthStart(AddMonths(Max(Date),-12)))<$(=MonthEnd(Max(Date)))"}>} [NbCustomer])

agigliotti
Partner - Champion
Partner - Champion

you can use set analysis also for CustomerGroup like below:


Sum({$<Month=, Year=, Date={">=$(=MonthStart(AddMonths(Max(Date),-12)))<$(=MonthEnd(Max(Date)))"}, CustomerGroup = {"1"} >} [NbCustomer])


this will only filter CustomerGroup  = 1 regardless which CustomerGroup you selected, else you can use CustomerGroup *= {"1"} to take care also of CustomerGroup selections.

Not applicable
Author

Thank you everyone! Now it works.

Kind regards,

Sofia