Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can you remove dimension values if there is no data, how?

Team,

There is some data that has a few expression calculations.  Dimensions are  being used to show the data for the axis.  How do I stop dimensions from showing on axis if there is no data.  Seems it would be simple, but I am missing it at the current time.

Look at the attached combo chart, in this chart, since there is no expression data for:

Train 11mrt22_29 and Spritn W30_33

Train 11mrt30_37 and Spritn W26_29

how do I make the W30_33 option NOT show in Train 11mrt22_29     and

how do I make the W26_29 option NOT show in Train 11mrt30_37

In essence, it would great if the chart only had two columns on the horizontal axis and the sets where there is no data would not show.

Note, drill ins occurr into this data as you can see.  The simple .qvw file is attached.

Thanks,

D

17 Replies
Not applicable
Author

Swuehl,

Awe, so I am hitting a bug that is limiting me.

Our company is using 9.00.7649.9 SR6 and I unfortunately can not drill in on the right. Logically seems it would work, but I have battled this a couple times now.

This is a bug in version 9 SR6 then.

That stinks. I should report this to the folks at my company that interface with Qlikview support, maybe a fix will come in the near future on V9.

Thanks,

jduenyas
Specialist
Specialist

Did you try to set the "Suppress When Value Is Null" in the Dimension's tab of the Chart's Properties Sheet?

swuehl
MVP
MVP

I can confirm that 9 SR6 does not drill in, 10 SR3 does. Though it seems that even 10 SR3 has a problem if I add a separator (&'-'&) inbetween the two field names.

So I think the problem is the calculated dimension in a group. Without trying myself , you could try to add a combined field in the script instead.

Not applicable
Author

Ah, will give a try and let you know, thanks…………………

Not applicable
Author

Yes, seemed to still have an issue.

Not applicable
Author

Swuehl,

That nailed It for V9 SR6.

Changed the load to combine the fields and all ok, can drill at will….

Thanks,

swuehl
MVP
MVP

Just checked in 9 SR6: What does work is using a cyclic group instead of drill down group.

Though this requires an additional click, but may have also the charm to see the lower levels without the need to restrict to one value on higher level.

Have a nice day / evening.

swuehl
MVP
MVP

Ah, just read your latest response.

good to hear!