Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
ashokraju
Contributor II
Contributor II

Barchart

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.

4 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

You can use function CLASS()

Regards,

Andrey

Anonymous
Not applicable

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.

ashokraju
Contributor II
Contributor II
Author

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

ahaahaaha
Partner - Master
Partner - Master

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