This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
Ok, I see. So what more needs to be done now??
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...
My category is not based on Profit% , It's only on sum(Profit) .....
Its a typo .....Sorry for that.
Thanks for the mention Christophe.
It is working Christophe...I checked again....
But there is one problem....it will depend on the order of Profit% category selection.
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.