Discussion board where members can get started with Qlik Sense.
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.