Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

Hide unrelated dimension values in bar chart


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

8 Replies
brindlogcool
Contributor III

Re: Hide unrelated dimension values in bar chart

Are you able find any solution for your problem?

Not applicable

Re: Hide unrelated dimension values in bar chart

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

brindlogcool
Contributor III

Re: Hide unrelated dimension values in bar chart

It did checked in the attached example

Not applicable

Re: Hide unrelated dimension values in bar chart

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

Not applicable

Re: Hide unrelated dimension values in bar chart

Hi Dathu,

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

Regards,

Anosh

MVP
MVP

Re: Hide unrelated dimension values in bar chart

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

Not applicable

Re: Hide unrelated dimension values in bar chart

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

Partner
Partner

Re: Hide unrelated dimension values in bar chart

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