Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I'd like to convert a measure into dimension so that we can do counting on that.
Below is a simple example:
Customer Price
A 1.0
B 1.0
C 1.1
D 1.2
E 1.2
F 1.2
We have price (measure) for customer above, and want to count Number of Customers on price based. Below is what we want:
Price Num of Customers
1.0 2 (A&B)
1.1 1 (C)
1.2 3 (D&E&F)
Appreciate if if anyone could advise how to achieve this in Qlik Sense front end? I mean not do the conversion in script.
Thanks!
Derek
You can convert measures into intervals using class function.
See class function for more details.
Hope this helps.
Hi,
Simple way (eg: if trying to achieve in a bar chart) is taking Price as a dimension and Count(distinct Customer) as measure ,gives count of distinct customers against appropriate Prices.
Hope this helps,if this is the requirement.
Try this
Dimension
Price
Expression
Count(DISTINCT Customer)