Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

divyanshi
New Contributor II

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
praveenkumar_ma
Contributor

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

Hi Divyanshi ,

Can you able to share any file , i didnt understood properly .

If ypu can share anysample , its easy to work on please.

Thanks

PM

divyanshi
New Contributor II

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

Hi Praveen,

PFA of qvf as well as the excel.

In the qvf, I have grouped according to QoQ on customer group selection. But I want grouping should be automatically done on Leaders as well as at org level(no selection of filter), YoY Trend(only on Fiscal Year).

Like as of now,

for Q4 , <0%, sum(Profit) is -0.72 and sum(Cost) is 47.78 which is correct.


And I want

for no quarter selection, sum(Profit) is 0 and sum(Cost) is 0

for L1 Leader and no quarter selection , sum(Profit) is -8.6 and sum(Cost) is 1.76

for L1 Leader and Q4 , sum(Profit) is -0.2 and sum(Cost) is 45.56


You can check from attached excel....


Kindly help.


devyanshu_gupta
New Contributor III

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

Hi,

Here lets say if you're making a straight table.

Make a calculated dimension using the radio buttons input

For Measure try

if(Sum(Profit)<0,'<0%',

     if(Sum(Profit)<10,'0-10%',

          if(Sum(Profit)<20,'10-20%','>20%'

            )

       )

   )


Here the values would be easily filterable by Leaders, Quarter, etc...


Regards,

Devyanshu

divyanshi
New Contributor II

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

Can you manipulate the app file I shared?

christophebraul
Contributor III

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

Hi,

Find my App attached below.

I'm using cyclic group in Qlik sense, you can have full detailed implementation at https://www.quickintelligence.co.uk/qlik-sense-cycle-group/ from stevedark

Then, grouping are calculated in the list using aggr(). this ensure your list will be updated with any other selections in the app

I've renamed Customer Group to Customer group in the data island. The field name and the value in the dimension have to be the same.

divyanshi
New Contributor II

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

stalwar1

Kindly help.

Highlighted
devyanshu_gupta
New Contributor III

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

Check now

divyanshi
New Contributor II

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

Thanks Christophe...

But you are using

Sum(Profit)/(Sum(Profit)+Sum(Cost))


while I am calculating sum(Profit) on sum(Profit) categorization.

divyanshi
New Contributor II

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

Thanks Devyanshu ...

But I have to use that Profit category thing in filter only.