topic Re: Writing condition on measure column in QlikView

Writing condition on measure column

Tue, 30 Apr 2013 06:34:05 GMT

Hi All,

I need to develop one pie chart report in qlikview ,source for this report is Sql Server 2008R2.

In fact table having one measure value like IsScaning which can store either 0 or 1. In piechart need to display counr IsScaning=1 and Isscaning=0.

In qlikview reportng tool I can able to select Measure column in chart expressions.But I'm not able to specify any condition over that measure like IsScaning=0 or IsScaning =1.

Can you please guide me how can I achive this one using QlikView reporting tool.

Regards,

Praveen Cirivelu

Re: Writing condition on measure column

Tue, 30 Apr 2013 06:37:42 GMT

Hi,

Try using If condition in expression of pie chart.

count(if(IsScaning=0,Measure value,

IsScaning=1,Measure value))

Hope this helps.

Regards,

Amay

Re: Writing condition on measure column

Tue, 30 Apr 2013 07:07:01 GMT

Hi,

Its not working,I need to display Countof IsScaning=0 and IsScaning=1.In same piechart need to display both measures.

Re: Writing condition on measure column

sushil353 — Tue, 30 Apr 2013 07:10:57 GMT

do u want to show to expressions?

if yes then try this

exp1:

count(if(IsScaning=0,Measure value)

exp2:

count(if(IsScaning=1,Measure value)

if you want to implement the AND condition in one expression then try this:

count(if(IsScaning=0 and IsScaning=1, Measure value)

if still your issue is not resolved then post the sample app.

HTH

Sushil