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

[sadabala_bi]

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

[undergrinder]

Hi Sattipandu,

Check this extension: Qlik Branch

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

G.

[Anonymous]

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

[sadabala_bi]

Thanks undergrinder

its working fine.

Thanks for your valuable suggestion .

Thanks

Sattipandu

[undergrinder]

I'm glad to help you