6 Replies Latest reply: May 21, 2017 10:07 PM by sivasankar kanagasabai

# 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 ,

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

• ###### Re: what if analysis possible in Qlik

Any Suggestion Please ,is this requirement possible in Qlik?

• ###### Re: what if analysis possible in Qlik

Hello Naveen,

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

Qlik Branch

Regards!

Rahul

• ###### Re: what if analysis possible in Qlik

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

• ###### Re: what if analysis possible in Qlik

Any more suggestion on the above requirement plz

• ###### Re: what if analysis possible in Qlik

I can only see this working with an INPUTFIELD;

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