Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Keep blank value fields

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 

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Re: Keep blank value fields

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

zhadrakas_0-1589963344560.png

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

zhadrakas_1-1589963393160.png

zhadrakas_2-1589963402635.png

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

 

 

 

View solution in original post

5 Replies
Highlighted
Partner
Partner

Re: Keep blank value fields

hi 

on your section dimension 

check both - 

show all values 

suppress when value is null

and you'll get what you want 

Highlighted
Creator III
Creator III

Re: Keep blank value fields

@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 

Highlighted
Creator III
Creator III

Re: Keep blank value fields

Any help on my post ? 

Highlighted
Partner
Partner

Re: Keep blank value fields

hi 

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 

Highlighted
Specialist II
Specialist II

Re: Keep blank value fields

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

zhadrakas_0-1589963344560.png

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

zhadrakas_1-1589963393160.png

zhadrakas_2-1589963402635.png

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

 

 

 

View solution in original post