Input Box

[ayush]

Hi All,

I have a scenario, I have some students named a,b,c,d and they have some marks like 33, 05,99,100 and a pass percentage but user wants that the pass percentage should be input by himself so that he can analyse as per him, he is gonna decide the pass percentage value.. and based on his input the other corresponding charts present in the sheet will interact.

1. Where/How can I get a box where I can put the values in Qliksense and see the data change? I am using Qliksense June 2019 version.

[msKarthikeyan]

Hi,

You can use a variable input and select input box in 'Show as'.

The variable should be used in all charts for determining the pass percentage.

-karthik 

[ayush]

Thank you so much for the reply,

can you please elaborate this more as I don't have input box. 

[msKarthikeyan]

Hi Ayush,

Variable input is available in the dashboard bundle.

check if you have it installed. 

if its available, you can use input box type to set value to a variable (which will be your passing score) 

-Karthik 

[ayush]

Thanks karthik

Wonderful, 

I didn't have bundle installed in my machine so i re installed it and got input variable box.

In the data, I have Annual turnover field so I have to create small, medium and large category in it. User will use the input box and as per him will input values see the data change in other visuals. e.g. in Small category he put 5000 and in medium in put 10000

How can i achieve this using variable, please help me with creating and applying variable.

[msKarthikeyan]

Hi Ayush,

Is my understanding correct? 

Two Inputs 

$(vSmall) - 5000

$(vMedium)  - 10000

If(annual turnover < $(vsmall) , 'Small company' , If(annual turnover < $(Vmedium) , 'Medium' ,'Large'))

In this case you can use this as the dimension in chart:

=if(ATO<$(vSmall),'Small', if(ATO<$(vMedium),'Medium','Large'))

-Karthik 

[ayush]

Hi karthik,

You are almost correct,

Let me know do I need to create these variable firstly?

$(vSmall) - 5000

$(vMedium)  - 10000

and then proceed with applying the logic in dimensions of those charts

[msKarthikeyan · Accepted solution]

Yeah you have to create two variables. and set the values for the variable using the variable input.