Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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!
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!
Hi Ruben , it's perfect !
Very interesting function, i am gonna use it for other works !
thx.++
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 ?
++
Not exactly above, but you can add the empty row after 'X' headers adding an empty calculated dimension.
very nice
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 !
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
Good job Ruben ! (99.9 % close to target )
It's kind of strange that those kind of basics options are not in default settings !
++