Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
maxime66
Creator
Creator

Customers between 2 ages

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)

1 Solution

Accepted Solutions
rubenmarin

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!

View solution in original post

8 Replies
rubenmarin

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
Creator
Creator
Author

Hi Ruben , it's perfect !

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

thx.++

maxime66
Creator
Creator
Author

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
Partner - Creator III
Partner - Creator III

very nice

maxime66
Creator
Creator
Author

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
Creator
Creator
Author

Good job Ruben ! (99.9 % close to target )

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

++