topic Re: How to freeze dimensions in QlikView

How to freeze dimensions

waszcma1 — Thu, 07 Nov 2019 19:25:45 GMT

Hi Could you help me to solve some modeling data problem please?

I have 2 tables:

Product:
load * inline
[PID
x1
x2
x3
x4
x5];

Stock:
Load * inline
[PID, qty, warehouse
x1,1,A
x1,2,B
x3,1,A
x3,8,B
x5,6,C];

The output is pivot table

PID	sum(qty)
x1	3
x2	0
x3	9
x4	0
x5	6

when i use selection field "warehouse" and select i.e. A

Tables shows only

PID	sum(qty)
x1	1
x3	1

how can I keep view frozen (all PID always displayed)

I would like to achieve something like this

When selecting warehouse A

PID	sum(qty)
x1	1
x2	0
x3	1
x4	0
x5	0

Re: How to freeze dimensions

Pujitha — Thu, 07 Nov 2019 19:51:30 GMT

I need some clarification in the question - You need to achieve like if you select warehouse A

In the table it should show all PID's not only X1 and X3 which belongs to only A. Is that you want to achieve. Help me if I am wrong in understanding your question.

X1 1

X2 0

X3 1 ..

Re: How to freeze dimensions

waszcma1 — Thu, 07 Nov 2019 20:29:42 GMT

Exactly as you wrote

After selecting warehouse A QV will display table with only 2 rows, PID (x1, x3) but other rows which refering to x2,x4,x5 will gone.

I would like to keep the table view always with 5 rows PID(x1, x2, x3, x4, x5) but after selecting A

it should calculate qty only for x1 and x3, others qty should be 0

Re: How to freeze dimensions

chakshu_jain — Fri, 08 Nov 2019 02:24:02 GMT

Hi Waszcma

I think there is a simple solution to this. In the presentation tab if you uncheck 'Suppress zero values' and 'Suppress missing' that should do the trick.

Have a look at the attached and if I understood your question right this should work.

Thanks

Re: How to freeze dimensions

waszcma1 — Fri, 08 Nov 2019 07:26:24 GMT

This is exactly what I need but there is still something odd.

I copied the table to my app and it works but when I checking second table i cant uncheck Suppress missing

on your table it is unselected? I dont know why in my application i cant change this option in properties?

Re: How to freeze dimensions

waszcma1 — Fri, 08 Nov 2019 09:51:22 GMT

Finally I have found the reason

In my table under Chart properties -> Dimensions i should tick Show All Values

Thank you for your help!