Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sarfaraz_sheikh
Contributor III
Contributor III

How to add dummy dimension in Pivot level chart

Dear All,

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

Sarfaraz

3 Replies
sunny_talwar

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.

antoniotiman
Master III
Master III

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

Kushal_Chawda

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'