topic Customers between 2 ages in QlikView

Customers between 2 ages

maxime66 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 29 Apr 2016 10:06:07 GMT

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 — Fri, 29 Apr 2016 11:11:09 GMT

Hi Ruben , it's perfect !

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

thx.++

maxime66 — Fri, 29 Apr 2016 11:46:36 GMT

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 — Fri, 29 Apr 2016 12:00:29 GMT

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

florentina_doga — Fri, 29 Apr 2016 14:24:58 GMT

very nice

maxime66 — Fri, 29 Apr 2016 14:44:43 GMT

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 — Fri, 29 Apr 2016 15:47:40 GMT

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 — Mon, 02 May 2016 07:56:26 GMT

Good job Ruben ! (99.9 % close to target )

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