Discussion board where members can get started with Qlik Sense.
I'd like to convert a measure into dimension so that we can do counting on that.
Below is a simple example:
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.
Go to Solution.
You can convert measures into intervals using class function.
See class function for more details.
Hope this helps.
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.