How to make Profit% category at front end in qliksense?

[divyanshi]

Hi All,

I have two columns:     Customer Group and Customer Name

And I have one radio button:

I want to categorize all customer group as well as customer name on the basis of sum(Profit) depending upon the selection of customer selection filter as:

sum(Profit)<0      ->                                    "<0%"

sum(Profit)>=0 and sum(Profit)<10      -> "0-10%"

sum(Profit)>=10 and sum(Profit)<20      -> "10-20%"

sum(Profit)>=20    ->                                  ">=20%" 

Also I have one leaders filter , I want when someone selects any leader then grouping should be done corresponding to leaders as well in addition to customer group/customer name.

Kindly help...

[devyanshu_gupta]

Ok, I see. So what more needs to be done now??

[christophebrault]

Since your field Profit is a %, you should'nt do a Sum, no ?

If you don't have access to original data, you have to make calculation at the finest level in charts. Not the best way to use Qlik...

[divyanshi]

My category is not based on Profit% , It's only on sum(Profit) .....

Its a typo .....Sorry for that.

[stevedark]

Thanks for the mention Christophe.

[divyanshi]

It is working Christophe...I checked again....

But there is one problem....it will depend on the order of Profit% category selection.

Eg:

If I select Q4 first and then <0%....it works fine

But if I select <0% first and then Q4....it is giving wrong answer.