Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, i am working on Share Of Business simulation concept . so far i worked partially and i got a show stopper ,
so for above material we got 3 different vendors and i am showing there share of business in percentage wise .which are
58.20 for 1st vendor
36.95 for 2nd vendor
4.85 for 3rd vendor
100% total
so my requirement is WHAT IF
% Of that Vendor changes
let say if i change 1st vendor from 58.20 to 50 %
and the 2nd vendor from 36.95 to 25%
so third vendor should dynamically should get remaining percentage which is 25% because total has to be 100%
then what will be the Net Qty
expression :
% of that vendor
If(Count(TOTAL <[Material Description]> [Vendor Name])>1, Sum([Net Qty]) / Sum(TOTAL <[Material Description]> [Net Qty]))
Is it possible to change % percentages of each vendor individually ,in the same chart or do i need to take any different chart and input box to enter the values and assign a variable to carry those entered values
Is this requirement possible in QLIK. what processor do i need to follow please
thanks
naveen
Any Suggestion Please ,is this requirement possible in Qlik?
Hello Naveen,
Please refer my email. You can fix this by using below given extension.
Regards!
Rahul
Hello Rahul,
Thanks for your help but Rahul I think u had miss understand the requirement ,
when variable is selected 100% it is showing values whose sum will be 100% and when I select 70% it is showing values whose sum will be only 70%
but my requirement is total should not be changed which is 100%,only the values has to be change
like this
58.20 for 1st vendor
36.95 for 2nd vendor
4.85 for 3rd vendor
100% total
so my requirement is WHAT IF
% Of that Vendor changes
let say if i change 1st vendor from 58.20 to 50 %
and the 2nd vendor from 36.95 to 25%
so third vendor should dynamically should get remaining percentage which is 25% because total has to be 100%
IS this requirement really possible in Qlik
Thanks
Naveen
Any more suggestion on the above requirement plz
I can only see this working with an INPUTFIELD;
BUT, unfortunately, that's not supported yet in QlikSense ( mto )
Check this document What If Analysis in Qlikview.docx