Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

One conditional expression in chart

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

0 Replies