Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

what if analysis possible in Qlik

Hello, i am working on Share Of Business simulation concept . so far i worked partially and i got a show stopper ,Untitled.png

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









6 Replies
kunkumnaveen
Specialist
Specialist
Author

Any Suggestion Please ,is this requirement possible in Qlik?

rahulpawarb
Specialist III
Specialist III

Hello Naveen,

Please refer my email. You can fix this by using below given extension.

Qlik Branch

Regards!

Rahul

kunkumnaveen
Specialist
Specialist
Author

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






Untitled.pngUntitled1.png



Thanks

Naveen

kunkumnaveen
Specialist
Specialist
Author

Any more suggestion on the above requirement plz

OmarBenSalem

I can only see this working with an INPUTFIELD;

BUT, unfortunately, that's not supported yet in QlikSense ( mto‌ )

Siva_Sankar
Master II
Master II

Check this document What If Analysis in Qlikview.docx