Customers between 2 ages

[maxime66]

Hi Qlikers !

I would like to display Graphicly the number of customers between 2 ages :

- 2 dimensions et one simple expression ( =count(distinct customer_id)

- Without modiying my script.

- User need to adjust the range (see cursor in Qvw)

Thanx for your help ! (PNG of what i expect in the Qvw file)

[rubenmarin · Accepted solution]

Hi Maxime, please take a look at the attachment. I create the dimensions using ValueLoop(), and the expression also checks these ValueLoops.

Hope this helps!

[maxime66]

Hi Ruben , it's perfect !

Very interesting function, i am gonna use it for other works !

thx.++

[maxime66]

One last think Ruben,

do you know if there is a way to put X label on top of data and not as a column ?

++

[rubenmarin]

Not exactly above, but you can add the empty row after 'X' headers adding an empty calculated dimension.

[florentina_doga]

very nice

[maxime66]

Yes good idea,

but my issue is that i put grey color on lines (1 on 2) and i have this useless white column just after the Y ...

anyway thanks again , users will be happy !

[rubenmarin]

Hi Maxime, closer I can get is using a macro to set the widht of the colum: Re: setting column widths using a macro

Changing a bit the labels... still there is a thin white line, and the X label is shown in grey background

[maxime66]

Good job Ruben ! (99.9 % close to target )

It's kind of strange that those kind of basics options are not in default settings !

++