Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

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

Re: what if analysis possible in Qlik

Any Suggestion Please ,is this requirement possible in Qlik?

rahulpawarb
Valued Contributor II

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

kunkumnaveen
Contributor III

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






Untitled.pngUntitled1.png



Thanks

Naveen

kunkumnaveen
Contributor III

Re: what if analysis possible in Qlik

Any more suggestion on the above requirement plz

OmarBenSalem
Esteemed Contributor

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‌ )

Siva_Sankar
Honored Contributor

Re: what if analysis possible in Qlik

Check this document What If Analysis in Qlikview.docx

Community Browser