Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Try using If condition in expression of pie chart.
Hope this helps.
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
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.