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

[#1]

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

[swuehl]

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

[jduenyas]

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.

[#4]

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,

[#5]

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,

[#6]

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,

[#7]

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,

[swuehl]

I am not sure if I understood... maybe like attached?

[#9]

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,

[swuehl]

Just checked...

I use QV 10 SR3, if I click on any bar in the right  chart, I drill in. Strange...