topic Re: Create a range or bands in qlikview chart in QlikView

Create a range or bands in qlikview chart

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

Any suggestions on creating a low and high band/range in qlikview charts like below?

Limit Band
Low	High	Metric 1	Metric 2	Metric 3
0	0.5M
0.5M	1.0M
1.0M	1.5M
1.5M	2.0M
2.0M	2.5M
2.5M	5.0M
5.0M	7.5M
7.5M	10.0M
10.0M	15.0M
15.0M	20.0M
20.0M	25.0M
25.0M	50.0M
50.0M	100.0M
>	100.0M
Total

Re: Create a range or bands in qlikview chart

Anil_Babu_Samineni — Wed, 31 Jan 2018 14:59:40 GMT

Not sure, What is the question here?

Re: Create a range or bands in qlikview chart

kaushiknsolanki — Wed, 31 Jan 2018 15:02:11 GMT

Hi,

Yes it is possible using If statements in Script.

Regards,
Kaushik Solanki

Re: Create a range or bands in qlikview chart

zebhashmi — Wed, 31 Jan 2018 15:37:51 GMT

May be that can help

Class function

Re: Create a range or bands in qlikview chart

newqlik2017 — Wed, 07 Feb 2018 14:35:47 GMT

So, here's what I'm looking for

The metrics (Metric 1, Metric 2) on the table are expressions.

The low and high bands is dimension. I got the count of accounts and account balance from the sql script. Now, I need to assign values for Metric 1 and Metric 2 to the respective bands. For examples,

if there are 3 accounts with the account balance of 300,000 for a given policy then it would be 0-0.5M band
if there are 5 accounts with the account balance of 900,000 for a given policy then it would be 0.5-1.0M band

if there are 10 accounts with the account balance of 1,500,000 for a given polity then it would be 1.5-2.0M band and so forth....

My goal is how to create the band and should it based on the account balance field or can I also somewhere create an island table and link to the main table somehow?

Band		Metric 1	Metric 2
Low	High	Count of accounts	Account Balance
0 M	0.5 M	3	300,000
0.5 M	1.0 M	5	900,000
1.5 M	2.0 M	10	1,500,000
2.0 M	2.5 M
2.5 M	5.0 M
5.0 M	7.5 M
7.5 M	10.0 M
10.0 M	15.0 M

Thanks

Re: Create a range or bands in qlikview chart

newqlik2017 — Wed, 07 Feb 2018 14:59:38 GMT

Not sure if I can use class function as my intervals are not always the same.