topic Re: chart problem in QlikView

chart problem

Fri, 23 Dec 2016 11:26:36 GMT

Hi,

everyone, I met a problem below, I don't know why the result is in the chart,

Could anyone explain it to me?

MK_QSL — Fri, 23 Dec 2016 11:41:15 GMT

if(count({<flag={'1'}>}sales)=0,'exception','normal')

awhitfield — Fri, 23 Dec 2016 11:43:23 GMT

What are you actually trying to achieve here?

Andy

Gysbert_Wassenaar — Fri, 23 Dec 2016 11:43:58 GMT

'Flag' is not the same field as 'flag'.

And null values will not be counted so you'll never see the value 'exception'

Perhaps this does what you want: if(count({<flag={'1'}>}sales) + sum(0)=0,'exception','normal')

Anil_Babu_Samineni — Fri, 23 Dec 2016 11:56:04 GMT

Do you mean this?

sunny_talwar — Fri, 23 Dec 2016 12:03:49 GMT

Another way to do if without using if

Pick(RangeSum(flag, 1),'normal','exception')

sunny_talwar — Fri, 23 Dec 2016 12:30:55 GMT

I think I turned it around.... should have been this:

Pick(RangeSum(flag, 1),'exception','normal')