topic Re: Keep blank value fields in QlikView

Keep blank value fields

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

PLease find the attachment of the QVW file .

I have table and a filter selection , My requirement is like when you make selection from the filter (List Box) the table

should show the Sct 1, Sect 2 and Sect 3 as it is even if there is no data .

But current behaviour is like :

When I select any department then the table will diplay only those value which it has .

I have even unchecked suppress null values . Show Value wil show one extre filed which should not show .

Thanks

lironbaram — Tue, 19 May 2020 06:33:54 GMT

on your section dimension

check both -

show all values

suppress when value is null

and you'll get what you want

smilingjohn — Tue, 19 May 2020 06:46:18 GMT

@lironbaram Thanks for the reply ,

I followed your steps but could not achive .

It will show only Sect 2 and Sect 3 and hides Sect 1 .

I want to show all the Sect even if there is not data .

Thanks

smilingjohn — Tue, 19 May 2020 19:44:50 GMT

Any help on my post ?

lironbaram — Wed, 20 May 2020 07:36:38 GMT

i didn't find any solution with the current data format

you could create dummy records for each option , so you want encounter this

i'll try to see if there is a work around it

zhadrakas — Wed, 20 May 2020 08:32:16 GMT

if you check only the "Show all Values" tickbox it should work

then you will always see all sections even if there is no data:

at least it works for me here. tested in QV 12.3 SR2