topic Re: Show all data in QlikView

Show all data

Fri, 05 Dec 2014 03:34:52 GMT

Hi All,

I have 2 tables:

Load * Inline

[Region

Brazil

Italy

Japan

];

Load * Inline

[Region,Revenue

Brazil,1

];

But when I use Pivot table to show the Revenue By Region, it only shows Brazil, how can I show all regions even there is no revenue in the second table?

Thanks.

Re: Show all data

Fri, 05 Dec 2014 03:42:36 GMT

Hi,

Presentation-->uncheck Suppress Zero values

Re: Show all data

ecolomer — Fri, 05 Dec 2014 04:18:47 GMT

Select option "Show all values" in dimension

Re: Show all data

jyothish8807 — Fri, 05 Dec 2014 04:43:12 GMT

Hi Isaac,

PFA

Regards

Re: Show all data

prma7799 — Fri, 05 Dec 2014 04:49:25 GMT

Hi,

1) Go to Presentation

2) Unchecked Suppress Zero-values

Thanks,

Prashant

Re: Show all data

ashwanin — Fri, 05 Dec 2014 04:53:26 GMT

Go to chart properties-->Presentation-->Region-->Supress Zero Value