topic Hide unrelated dimension values in bar chart in QlikView

Hide unrelated dimension values in bar chart

Thu, 23 Jan 2014 22:31:30 GMT

Hi All,

I have attached an example qvw where I have a bar chart and I want to hide the dimension values for sites which are not associated to their country.

Hide S1, S2, S3, S7, S8 , S9 for China

Hide S4, S5,S6,S7,S8,S9 for India etc

The chart should display only those dimension values where data is present. Please guide me how can i do this.

Qlikview doesn't show data when displayed in straight table or pivot table but it creates dummy dimension for bar charts.

I am attaching data & screenshot for those who cannot open below qvw:

LOAD

* INLINE

[
Country, Site, NoOfPatients
India, S1, 12
India, S2, 1
India, S3, 17
China, S4, 1
China, S5, 15
China, S6, 11
UK, S7, 12
UK, S8, 1
UK, S9, 10
]

;

Thanks & Regards,

Anosh

Re: Hide unrelated dimension values in bar chart

brindlogcool — Fri, 24 Jan 2014 23:07:53 GMT

Are you able find any solution for your problem?

Re: Hide unrelated dimension values in bar chart

Fri, 24 Jan 2014 23:40:02 GMT

Please check the "Suppress Zero Values" on the Presentation Tab.

Re: Hide unrelated dimension values in bar chart

brindlogcool — Fri, 24 Jan 2014 23:43:12 GMT

It did checked in the attached example

Re: Hide unrelated dimension values in bar chart

Fri, 24 Jan 2014 23:46:16 GMT

Currently I can't open the qvw file. I am suspecting he is using Site dimension multiple times ?

Re: Hide unrelated dimension values in bar chart

Sat, 25 Jan 2014 16:45:10 GMT

Hi Dathu,

Thanks for your reply. I am not using Site dimension multiple times. The dimensions of the chart are Country, Site.

Regards,

Anosh

Re: Hide unrelated dimension values in bar chart

maxgro — Sat, 25 Jan 2014 20:30:31 GMT

a workaround would be to create a single dimension (=Country & '-'& Site) instead of Country and Site

Re: Hide unrelated dimension values in bar chart

Sat, 25 Jan 2014 22:50:43 GMT

Hi Massimo, thanks for your reply. I tried this also but I dont want that.

Re: Hide unrelated dimension values in bar chart

phaneendra_kunc — Sat, 25 Jan 2014 23:53:50 GMT

It is a default behavior in Qlikview as it will produce a scale that will suffice all possible combinations for the data. which here it is ended up having things that you dont want.

Only way i can think of is maxgro way...