How to add Dummy/Fake Values in Dimention ?

[#1]

Hi all,

I am new to qlikview and i am stuck in my bleow issue.

can someone please help me ?

How can we add dummy/fake values in Dimentiones ?

Example :

We have below values in Data and we are using straight table to show count of this.

1sigma,

2sigma,

3sigma

we do not have any any records with -1sigma and -2sigma,

but, still, we need to show this dimentione on the table.

we would like to see below output.

-2sigma    0

-1sigma    0

1sigma     100

2sigma     50

3sigma     25

currently, -2sigma and -1sigma is not showing on the table,

because we do not have any single records with this dimentiones.

how can we add this dummy dimentions ,

so, it will appear on the table ?

any help would be appreciated.

[nagaiank]

Try ValueList() function.

For more information see Synthetic Dimensions - ValueList() (Example)

[its_anandrjs]

In your fact add this two dimension values

Ex:- Suppose Dimension4 you have field then add values by the help of Inline tables.

Fact:-

Load

*,Dimension4 from Location;

Concatenate(Fact)

DummyData:-

Load

[

Dimension4

-2sigma   

-1sigma   

];

[#4]

Guess Anand's solution is the easiest to implement