Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody. Im new in Qlik and have some questions.
I have list boxes with multiple selection allowed:
-"Quarter" with 5 values (1,2,3,4,5). 5-means Year(not aggr) value.
I have to create pie chart with next expression definition
Count({<[XXX]={'0'}>} [XXX])
But i have to add to this definition condition that related to listbox "Quarter".
I can show sql request to explain what i want
qlik ones looks like
select count(XXX) from dataset where Quarter_Field in "Quarter Listbox Values"
and XXX=0
but i need something like
1. If Quarter_Listbox includes "5" then
select count(XXX) from dataset where Quarter_Field=5
2.If Quarter_Listbox in (1,2,3,4) then
and (Another_field is null or ceil(month(Another_field)/3) in "Quarter Listbox Values")
Thanx