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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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