topic How to add dummy dimension in Pivot level chart in QlikView

How to add dummy dimension in Pivot level chart

sarfaraz_sheikh — Mon, 27 Jul 2015 10:31:15 GMT

Dear All,

Can anybody tell me how to add dummy dimension in pivot level chart

Sarfaraz

Re: How to add dummy dimension in Pivot level chart

sunny_talwar — Mon, 27 Jul 2015 10:32:48 GMT

Not sure what you mean by Dummy Dimension, but if you mean to add a dimension which isn't available from the database, you can try ValueList() or ValueLoop() functions.

Re: How to add dummy dimension in Pivot level chart

antoniotiman — Mon, 27 Jul 2015 10:46:41 GMT

Hi,

I agree with Sunny.

If You use ValueList('a','b') as dimension, You need Expression Like

If(ValueList('a','b')='a',Sum(TOTAL <DIM> Value)) and so on.

See sample attachment.

Regards

Re: How to add dummy dimension in Pivot level chart

Kushal_Chawda — Mon, 27 Jul 2015 11:23:28 GMT

use Valuelist function

Go to chart properties -> Dimension tab

Add calculated dimension

=Valuelist ('Dummy1','Dummy2',..)

or if you want just single value as Dummy dimension, then add calculated dimension as below

='Dummyvalue'