topic Re: Conditional X-axis display in QlikView

Conditional X-axis display

hkg_qlik — Mon, 18 Apr 2016 19:46:21 GMT

Hi,

I would like to show only Jun-11, Jun-12, Jun-13.....Jun-16 (X-axis) for the below Line chart instead of showing ever Month-Year combination.

Re: Conditional X-axis display

swuehl — Mon, 18 Apr 2016 19:51:10 GMT

Maybe like

=If([Month-Year] LIKE 'Jun*', [Month-Year])

or a similar set expression in all aggregation functions.

Re: Conditional X-axis display

hkg_qlik — Mon, 18 Apr 2016 20:02:50 GMT

Actually I want to keep all month-year data and just display June-11, June-12 .....June-16 on the X-Axis with all the data in between.

Something like this:

Re: Conditional X-axis display

johnw — Mon, 18 Apr 2016 20:04:42 GMT

Maybe a Month field in addition to your Month-Year field, and just have them select June if they want to see all Junes. If it's ALWAYS June that we want to see, then a conditional dimension or set analysis as swuehl says, but it's easier to do either if you have a Month field.

Edit: Sorry, posted before I saw your reply.

Re: Conditional X-axis display

swuehl — Mon, 18 Apr 2016 20:09:17 GMT

Maybe like

=If([Month-Year] LIKE 'Jun*', [Month-Year], dual(' ', [Month-Year]) )

Re: Conditional X-axis display

johnw — Mon, 18 Apr 2016 20:14:08 GMT

Yep, that worked. Well, this, in one of my charts.

=if(month([Month])=6,[Month],dual(' ',[Month]))

But I'm confused HOW it worked. I thought dual could only assign a single numeric value to each text value, so expected this to confuse it.

Edit: I guess it's the other way around. You can only have one string representation for a given number, but you could have multiple numbers for the same string representation.

Re: Conditional X-axis display

swuehl — Mon, 18 Apr 2016 20:20:21 GMT

Hi John, a dual value can store a single text value per numeric value and the numeric value is considered the key, so it's the other way round

But be assured (referring to your other comment), I need to repeat and / or lookup myself a lot of the basic stuff each single day...

And unfortunately, some things are hard to remember, due to inconsistencies or flaws.