Hide unrelated dimension values in bar chart

[#1]

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

[brindlogcool]

Are you able find any solution for your problem?

[#3]

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

[brindlogcool]

It did checked in the attached example

[#5]

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

[#6]

Hi Dathu,

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

Regards,

Anosh

[maxgro]

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

[#8]

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

[phaneendra_kunc]

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...