topic Re: Barchart in QlikView

Barchart

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

hi..

I have an expression like "Margin" with records 1 to 1lakh (1,2,3...........10000000 ). I want to show a bar chart with ranges >10000,>20,000 and >50,000. I want to show count of Margin >10000 and >20000 and >50000. Could anyone please suggest.

Re: Barchart

ahaahaaha — Tue, 25 Apr 2017 07:56:31 GMT

Hi,

You can use function CLASS()

Regards,

Andrey

Re: Barchart

Anonymous — Tue, 25 Apr 2017 14:50:10 GMT

Here an example.

I used flag to categorize data and after i have created new table category. Fortunately, you will have to change your key in you category table.

Hope that it will help you.

Re: Barchart

ashokraju — Wed, 26 Apr 2017 06:08:05 GMT

Hi.It is not working for count of margin..pls suggest any other..

Re: Barchart

ahaahaaha — Wed, 26 Apr 2017 07:25:51 GMT

Hi,

As variant example in attached file.

Value - classifiable field.

Dimension:

=If(Value<20000, Class(Value, 10000, 'x'),

If(Value>=20000 And Value<50000, Class(Value, 30000,'x', 20000),

If(Value>=50000, Class(Value, 450000,'x', 50000)

)))

Expression:

Count (Value)

Regards,

Andrey