topic Re: Charts - two conditions in if-statement in QlikView

Charts - two conditions in if-statement

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have to build many charts using different conditions, displayed side by side.
It works as long as I can use only one.

Data: 2014-2017

Dimension =if(match([Year], '2017'), Country)
Formula =sum(if(match([Year], '2017'), Duration))

I want to display only Year '2017' AND Color 'Red'

Cheers,

Chris

sunny_talwar — Wed, 25 Jan 2017 22:01:16 GMT

May be try this

Dimension

Country

Exp:

Sum({<Year = {2017}, Color = {'Red'}>}Duration)

Anonymous — Thu, 26 Jan 2017 11:10:06 GMT

In addition - If you want to untie the selected criteria: you need to do

SUM({1<Year = {2017}, Color = {'Red'}>} Duration)