topic Re: Display barchart expression in QlikView

Display barchart expression

Fri, 21 Sep 2012 09:46:28 GMT

hi all,

Can we display bar chart with two calculation in a single expression. I had taken DEFECT as dimension.

DEFECT field contains rows as Chip, EdgeTear,Hole, etc.

Now i want to dispaly two calculations in a single expression.

i.e;

Sum(TPD) and

Sum(LC)-Sum({$<DEFECT='FAIL'> TPD}

All the defect rows should show its values based on first calculated expression each bar for Chip,EdgeTear,Hole,etc. and last bar should show based on second calculated expression.

Thanks in advance.

Regards,

Venkat.

Re: Display barchart expression

whiteline — Fri, 21 Sep 2012 09:50:06 GMT

Hi.

You can use if() if you know the condition for the last bar.

Re: Display barchart expression

Fri, 21 Sep 2012 09:58:11 GMT

hi thanks for your reply on this,

There is no condition, every time the last bar column should display and value of that bar should change based on filters selection.

Please find the attached app.

Thanks in advance.

Regards,

venkat

Re: Display barchart expression

Anonymous — Fri, 21 Sep 2012 10:13:30 GMT

Hi ,

Better you can use the Combo Chart for your requirement and i attached the your qv file with combo chart.

Hope it wil help

Regards

Ashok.

Re: Display barchart expression

Fri, 21 Sep 2012 10:20:18 GMT

Hi thanks for reply but this app not used to me bcoz i need to maintain only bar chart and single expression should display two calculated conditions.

is this possible ?

Thanks in advance.

Regards,

Venkat.

Re: Display barchart expression

Anonymous — Fri, 21 Sep 2012 10:25:05 GMT

Hi,

Hope its not possible to create two bar chart using single expression. For this you can use Stacked bar but here also you can use two expression but the result should show in single bar in stacked.

Regards

Ashok.

Re: Display barchart expression

whiteline — Fri, 21 Sep 2012 12:18:02 GMT

Ok, if the user select three values from DEFECT dimension, the expression are:

Chip -> Sum(TOTALPERDEFECT)

Chip/Tear -> Sum(TOTALPERDEFECT)

Curl ->sum(LENSCOUNT)-Sum({$<DEFECT={'FAIL'}>}TOTALPERDEFECT)

Right ?

If so, the good thing is that you could use =if(rowno()=NoOfRows(), Expression1, Expression2)

The bad thing is it seems NoOfRows() in QV11 returns +1 (counts total row).