I have a requirement to create Ranges based on measures and then use them as dimension to display other metrics.
Here is the table 1 I have ( Added Below), the last column Calculated Column - Item Range I get from the previous column Sales and has to be calculated in Qlikview.
Table 1
Calculated Column
Sales
Packs within Item
Item Range
Item 1
100
20
Item Range 1 ( 0 to 200 Sales)
Item 2
200
25
Item Range 1 ( 0 to 200 Sales)
Item 3
300
30
Item Range 2 ( 200 to 400 Sales)
Item 4
400
10
Item Range 2 ( 200 to 400 Sales)
Item 5
350
23
Item Range 2 ( 200 to 400 Sales)
Item 6
600
32
Item Range 3 ( 400 to 600 Sales)
The Requirement is to create a Bar chart with the below measures. Can you please suggest me how to achieve this.
Currently I am creating this range in the Load script and using that as a dimension in my chart. But this would remove any dynamic filters which can be used on this dimension. So I am looking for a better approach. Thanks !!
how you are creaing Item range in script? if answer is using interval match() function, then you have done it correctly. what do you mean by "Dynamic filters"?
>>But this would remove any dynamic filters which can be used on this dimension.
Creating a range field in script should not affect your ability to filter on this or other dimensions unless you are aggregating the records in the load. But perhaps I am not understanding your problem correctly. Do you mean you want to apply the ranges dynamically?
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
I am just using a normal if condition in the script.
I was referring to the normal selections being made in qlikview as the dynamic filters. Once I define my range based on the Sum(Sales), I will not be able to apply a filter on the sales measure used to define the range. For eg. I cant define a Range based on Sals only for US region. Since the group is already defined, I can only show the range at the global level.
