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: 
divyanshi
Contributor III
Contributor III

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

Hi All,

I have two columns:     Customer Group and Customer Name

And I have one radio button:

radio.PNG

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.

filters2.PNG

Kindly help...

14 Replies
devyanshu_gupta
Partner - Contributor III
Partner - Contributor III

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

christophebrault
Specialist
Specialist

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...

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
divyanshi
Contributor III
Contributor III
Author

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

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

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Thanks for the mention Christophe.

divyanshi
Contributor III
Contributor III
Author

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.