Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ngangrad
Partner
Partner

Dynamic column using Input values in variables

ngangrad_0-1610462702991.png

Hi Team,

I want to create individual dynamic column after I select the field from the dropdown and initialize the Volume Distribution and Insert Percentage value.

-> Requirement is when user select the Field name suppose "Sum of Q4 Number", for that selected field only it should divide   by the value which is given by user in volume Distribution input box and insert percentage input box.

Please help

We have two expression for Measure Sum of Q4 Number and SSC Quantity Unit

Sum of Q4 Number:
if(#Sales_Office = 'dist.', sum([Sum of Q4 Number]),
If(#Sales_Office = 'NA38',sum([Sum of Q4 Number]),
If(#Sales_Office = 'NA40',sum([Sum of Q4 Number]),
If(Top20>vInput,0, (sum([Sum of Q4 Number])*#vPercent)/100 ))))))
 
Sum of SSC Quantity:
if(#GetCurrentSelections($Field)='Sum of SSC Quantity',
if(#Sales_Office = 'dist.', sum([Sum of SSC Quantity]),
If(#Sales_Office='NA38',sum([Sum of SSC Quantity]),
If(#Sales_Office='NA40',sum([Sum of SSC Quantity]),
If(Top20>vInput,0, (sum([Sum of SSC Quantity])*#vPercent)/100 )))))

 

Please help

 @Michael_Tarallo , @sunny_talwar 

0 Replies