Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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?

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