Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
krishnakv83
New Contributor II

30 Days slider on KPIs

Hi All,

I created slider for 30 days variable.In my dashboard we have a two bar charts and 3 tables.Now I want to make slider that should respond all these metrics.The slider which I created working for one table not all the metrics. One table have planned and actual days but other tables or KPIs doesn't have direct relation with slider variable 30 days.

Is it possible to create slider to respond to all the KPIs?

Regards,

Venkat

7 Replies

Re: 30 Days slider on KPIs

That means, You are not engaging along with the variable. And all metric and/or objects works when we use the slider variable until unless it won't work

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
krishnakv83
New Contributor II

Re: 30 Days slider on KPIs

Hi Anil,

Thank you for the reply.

Remaining tables/charts are showing %, Margin and Quantity.I Don't know how to use this variable in those metrics.

How make relation to KPI with slider varible.

Pls give me some inputs.

Regards,

Venkat

Re: 30 Days slider on KPIs

Let's consider my query is use case of

Num(Sum(Sales), '#,##,#0%') -- This returns in %

So, You have 2 slides one from and one more is To that means the business user need to show one slider object / calendar object for selection for their prediction.

In this case If date is DateField and it consumes filter navigation using sliders from is Var1 and to is Var2

Then Analysis should be this?

Num(Sum({<DateField = {">=$(Var1) <=$(Var2)"}>} Sales), '#,##,#0%')


HTH

Anil

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
krishnakv83
New Contributor II

Re: 30 Days slider on KPIs

Anil,

I do not have two variables.Here my requirement is user will select 3 days or 5 days on the slider then all the KPIs should respond on this.

Regards,

Venkat.

Re: 30 Days slider on KPIs

Yes, That's where my explanation deserve. If still not matching my proposal i would ask you to share sample and result data set you want to see?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
krishnakv83
New Contributor II

Re: 30 Days slider on KPIs

My slider is not date field it is difference of the planned and actual days.so it has values 1 to 30 days difference.Min val 1 and max value 30.Varible is Diffof days which I created in the script.

Let me know your view what is var1 and var2 in my scenario also What should I define in Var2.

Regards,

Venakt

krishnakv83
New Contributor II

Re: 30 Days slider on KPIs

Hi Experts,

Please let me know your view on this requirement.

Regards,

Venkat