topic Re: Dynamically passing the values to a variable through an Input box in QlikView , Is this possible in QlikSense? in App Development

Dynamically passing the values to a variable through an Input box in QlikView , Is this possible in QlikSense?

sadabala_bi — Mon, 23 May 2016 06:41:54 GMT

Hi,

Here is my requirement,I want to get the TOP values based on the dynamic values that we passed.

QlikView:

This is possible through the InputBox Object.

I am passing the input value that we enter to an variable,

And i am writing the expression with that variable in the measure as

"Sum({<Dealer = {"=rank(sum(support_count))<= $(vTop)"}>}support_count)".

Its working fine as shown in the below Image.

QlikSense:

But in QlikSense There is no InputBox object.

So i cant pass the dynamic values to the variable.

As of my knowledge i can pass only one static value to a variable.

But i want this requirement in QlikSense as in QlikView.

Help me.

Thanks

Re: Dynamically passing the values to a variable through an Input box in QlikView , Is this possible in QlikSense?

undergrinder — Mon, 23 May 2016 12:02:50 GMT

Hi Sattipandu,

Check this extension: Qlik Branch

With qsVariable you can select button, inputbox, or slider and it is manipulate a variable.

Re: Dynamically passing the values to a variable through an Input box in QlikView , Is this possible in QlikSense?

Anonymous — Mon, 23 May 2016 14:40:35 GMT

Hi,

Download the variable extension and choose Render as field from and give name as vtop save it and use vtop in your above expression for the specific measure to be used in the chart or table...

Thanks

Chandra

Re: Dynamically passing the values to a variable through an Input box in QlikView , Is this possible in QlikSense?

sadabala_bi — Tue, 24 May 2016 06:04:06 GMT

Thanks undergrinder

its working fine.

Thanks for your valuable suggestion .

Thanks

Sattipandu

Re: Dynamically passing the values to a variable through an Input box in QlikView , Is this possible in QlikSense?

undergrinder — Tue, 24 May 2016 08:03:42 GMT

I'm glad to help you