Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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