Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

shekhar_analyti
Valued Contributor

How to calculate contribution in Revenue by non linked field based on user selection ?

Hi All ,

How to calculate contribution in Revenue by non linked field based on user selection ?

  • IF USER SELECTS VALUE 1 IN DROP DOWN THEN FROM Top_BU field Bode-Baumbach should be selected , and % of its contribution from total sales be calculated ... Likewise
  • IF USER SELECTS VALUE 2 IN DROP DOWN THEN FROM Top_BU field Bode-Baumbach and Cremin Group should be selected ,
  • IF USER SELECTS VALUE 3 IN DROP DOWN THEN FROM Top_BU field Bode-Baumbach,Cremin Group and Cummings should be selected
  • Similarly for 4 first four should be selected ... and likewise

Please refer the attachment for detail .

Thanks & Regards

Shekar

1 Solution

Accepted Solutions

Re: How to calculate contribution in Revenue by non linked field based on user selection ?

Here, I changed the expression for trigger to this

='=Count({1}DISTINCT TOTAL Top_BU) - Rank(Only({1}Top_BU)) + 1 <= vTop_X_BU'

Capture.PNG


View solution in original post

19 Replies
shekhar_analyti
Valued Contributor

Re: How to calculate contribution in Revenue by non linked field based on user selection ?

Top_BU is list of Business Unit arranged according to priority defined for Business Team ...  

Re: How to calculate contribution in Revenue by non linked field based on user selection ?

But Top_BU is sorted in order of Text? Is it a coincidence that Top_BU is in the same order of the ascending order of text? This makes me uncomfortable... are you sure you are putting your requirement in the right way?

shekhar_analyti
Valued Contributor

Re: How to calculate contribution in Revenue by non linked field based on user selection ?

Hi Sunny Bhai

Yeah Requirement is pretty similar to real time . And it is incidental that Top_BU is sorted , however in real time the data is not according to sorted order but according to priority set by Top level managements . I can see some BU starting with letter S on second and 3rd position in real time Data . Basic idea was the achieve or to enable the user to see % contribution by Top X business Unit ...

You can change the Top_BU order the way you want . I does not change requirement .

shekhar_analyti
Valued Contributor

Re: How to calculate contribution in Revenue by non linked field based on user selection ?

SAMPLE

Re: How to calculate contribution in Revenue by non linked field based on user selection ?

Are you able to create a field where you give the top_BU a ranking in the script based on what is decided by the top level management?

shekhar_analyti
Valued Contributor

Re: How to calculate contribution in Revenue by non linked field based on user selection ?

No i have not done that . Actually management based on their own criteria concludes the Rank for BU . I dont have privy to that . They only share excel sheet where in the BU in first row assumed to Top BU . You may consider 1 st record in excel to have rank 1 , 2nd one as rank second and likewise . And these order changes in every quarter .
So basically position of BU in excel sheet determines their "Topness" , if i may call it so ...

If user selects 3 from drop down then first 3 BU should be taken in set and their respective revenue % should be calculated ..

Re: How to calculate contribution in Revenue by non linked field based on user selection ?

Okay, which object are we calculating this in? What are the dimension?

shekhar_analyti
Valued Contributor

Re: How to calculate contribution in Revenue by non linked field based on user selection ?

Hi Sunny Bhai ,

Apologies for late response .

And Dimensions to begin with will be year wise : something like year wise contribution of Top X (user selects value X from drop down)  Business Unit ..

Object as Straight table to begin with

Thanks & Regards

Shekar

shekhar_analyti
Valued Contributor

Re: How to calculate contribution in Revenue by non linked field based on user selection ?

Sunny Bhai ... Can this be achieved now ?