Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Its not working,I need to display Countof IsScaning=0 and IsScaning=1.In same piechart need to display both measures.
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