topic How do we force X axis values to display in QlikView

How do we force X axis values to display

Anonymous — Wed, 08 Sep 2010 17:23:09 GMT

I have values 1,2,3,4 displayed on the X axis, each number has some metrics to display, for select dates, for some dates there is no data for 1 and 2 , so when i select that date only 3 and 4 are selected.Is there a way where i can display 1,2,3,4 on x axis with showing data for 3 and 4 ?

Thanks!

How do we force X axis values to display

johnw — Wed, 08 Sep 2010 17:37:27 GMT

Maybe checkmark "Show All values" on the Dimensions tab and/or uncheck "Suppress Zero-Values" and/or "Suppress Missing" on the Presentation tab?

How do we force X axis values to display

Anonymous — Wed, 08 Sep 2010 17:42:49 GMT

That is not working 😞

How do we force X axis values to display

johnw — Wed, 08 Sep 2010 17:54:40 GMT

Works for me for a simple example. See attached. So I've probably misunderstood the question. Can you post an example of it not working?

How do we force X axis values to display

Anonymous — Wed, 08 Sep 2010 17:57:45 GMT

oh wait , i am sorry i am mistaken , i actually have a calculated condition as my dimension , out of values 1-5 i do not want 5 to be displayed so i have

=IF(myfield<>'5',myfield)

do you think i need to have something like this in load script than in the expression?to diplay all values except 5 ?

How do we force X axis values to display

johnw — Wed, 08 Sep 2010 18:06:35 GMT

Ah, adding that to my example, it looks like that's what breaks it. Probably the problem is that QlikView then has no idea what the concept of "All Values" is, because it isn't storing a master list for your calculated dimension like it does for real fields. Yes, I think adding a real field should solve the problem. It fixes it in my example, anyway. See updated version attached.