topic Re: Display Missing column in QlikView

Display Missing column

Anonymous — Fri, 03 Mar 2017 15:42:06 GMT

Hi all

I have one table (T1) as below

System

Report 12a 12c 12f 12h

P 5 1 3 2

Q 2 4 5 1

R 3 2 2 4

Here we can notice columns 12b, 12d, 12e, 12g are missing. I want to display with 0 amount. I'm unable to insert QV file.

So if anybody can guide me.

Thanking you in advance

Re: Display Missing column

sunny_talwar — Fri, 03 Mar 2017 15:48:02 GMT

Are those values missing or null for the reports that are visible? May be try unchecking 'Suppress Zero Values' on the presentation tab and see if that helps

Re: Display Missing column

Anonymous — Fri, 03 Mar 2017 15:58:10 GMT

It's suppressing some other rows which already have zero/null amount

Re: Display Missing column

sunny_talwar — Fri, 03 Mar 2017 16:05:05 GMT

Not sure I understand your comment/question?

Re: Display Missing column

Anonymous — Fri, 03 Mar 2017 16:15:57 GMT

Let take this way

I have one table (T1) as below

System

Report 12a 12c 12f 12h

P 5 1 0 2

Q 0 0 0 0

R 3 2 0 4

- 0 0 0 0

In fact columns 12b, 12d, 12e, 12g are not exists at all, so I added through inline statement.

By this I am getting blank row at the end as above; now if I try to suppress It suppress all column and rows having null/zero values

Thanks

Re: Display Missing column

sunny_talwar — Fri, 03 Mar 2017 16:17:18 GMT

Try to 'Suppress When Value Is Null' on the dimensions tab for Report dimension