Writing condition on measure column

[#1]

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

[#2]

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

[#3]

Hi,

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

[sushil353]

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