One conditional expression in chart

Thu, 22 May 2014 16:59:05 GMT

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

and XXX=0

2.If Quarter_Listbox in (1,2,3,4) then

select count(XXX) from dataset where Quarter_Field=5

and (Another_field is null or ceil(month(Another_field)/3) in "Quarter Listbox Values")

and XXX=0

Thanx

topic One conditional expression in chart in QlikView