topic Re: Need Between drop down selections in QlikView

Need Between drop down selections

Thu, 16 Jan 2014 13:01:41 GMT

Hi Champs,

I have a requirement in which user should be able to select Revenue Between:

Revenue From (In Drop down)

Revenue To (In Drop down)

Please refer the attached Image.

I have a table box below the drop down selection in which the data should be filtered based on the Revenue range selection.

Can you please help me on this?

Thanks,

Praveen

Re: Need Between drop down selections

giakoum — Thu, 16 Jan 2014 13:09:32 GMT

Hi.

use 2 variables, add them to sliders for the user to choose range. Then use those expressions in a set analysis or if statement in your expression in the table, kind of like :

if(sum(value)>=bottomLimit and sum(value)<=topLimit, sum(value))

Re: Need Between drop down selections

Thu, 16 Jan 2014 13:40:40 GMT

Hi,

Business users are not intrested in the slider.They are expecting the Drop downs only.

Thanks,

Praveen

Re: Need Between drop down selections

giakoum — Thu, 16 Jan 2014 13:54:27 GMT

Then add them in a list box with predfined values.

Re: Need Between drop down selections

kiranmanoharrode — Thu, 16 Jan 2014 14:02:29 GMT

Dear Pravin,

Make 2 Inline Fields and Add your Specific records in those fields.

Then create 2 variables

vMin=Max(SalesFrom)

vMax=Max(SalesTo)

then Use Set expression.

=Sum({<Sales={">=$(vMin)<=$(vMax)"}>}Measure)

Regards
Kiran Rode

+91 8976977897

Re: Need Between drop down selections

Fri, 17 Jan 2014 05:39:49 GMT

Hi Kiran,

Can you please help me with an example.

Looks like I can't go with the set expression because after the Revenuew From and To selection...I would be seeing the list of companies thier state,city,zipcode..etc details.Am not showing any measures there.

Please let me know how can I use it.

Thanks & Regards,

Praveen Palle

Re: Need Between drop down selections

Fri, 17 Jan 2014 05:43:43 GMT

Hi,

Can anyone please help me with an example...need only drop down here.

Please let me know how can I use it.

Thanks & Regards,

Praveen Palle