Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
I think your problem is similar to that discussed in http://community.qlik.com/message/138827#138827
I also think that your drill ins make things more complicated...
There may be a better way but one which can help is to set the dimension(s) as such:
=if(UserStory.Train<>'' or not isnull(UserStory.Train),UserStory.Train)
Etc.
Swuehl,
What John came up with will work to an extent. What this does however is make the next layer that is presented show on the axis if any dimension is added after the combo dimension. How do I make it summarize at the combo dimension level and only show the next level is I drill in?
Thanks,
Jduenyas,
The original case Swuehl commented upon indicated that was tried and did not work. I have tried previously in another case to no avail, but let me try again, I was probably trying at the expression level previously.
Thanks,
Jduenyas,
I tried at the dimension level, does not seem to work. I believe because it is the combination of the two dimensions that leads to the null case. When I check both before setting or each on their own it did still left with the blanks.
=If( (Not isnull(UserStory.Train)) AND (Not isnull(UserStory.Sprint)), UserStory.Sprint )
Unless you are seeing it another way and I am missing it.
Thanks,
Swuehl,
The answer was spot on, do you know how to make this summarize at this newly created Train-Sprint dimension and not break out further than that until/unless you either click in or make a selection?
Thanks,
I am not sure if I understood... maybe like attached?
Swuehl,
Well, yes, but this does not drill any further than concatenated train-sprint value.
I want this initial presentation and then still be able to drill in to the others .
Would think easy, but surely is escaping me.
Ideas?
Thanks,
Just checked...
I use QV 10 SR3, if I click on any bar in the right chart, I drill in. Strange...