Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

selected the range

Dear all

i can create two varible  Vupperlimit,Vlowerlimit

user have to enter the range  through input box         lowerlimit    upperlimit

                                                                                    1                         6  

the data should in  the range only in  any table.

Tags (2)
4 Replies
Not applicable

Re: selected the range

Hi,

We can do this through Dimension Limits in a property page.

Re: selected the range

Hi,

Please check attached file.

Re: selected the range

Hi

Try like this

=Sum({<ID={">=$(=vLowerLimit)<=$(=vUpperLimit)"}>}Sales)

Re: selected the range

I used the csv file attached.

Created variables vLowerLimit and vUpperLimit.

Created input box & added those variables.

Created Straight table using ID as dimension

Expression as =Sum({<ID={">=$(vLowerLimit)<=$(vUpperLimit)"}>} Sales)

It works for me.

Also for selected field based report check this link

http://us.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs/Whats%20New%20in%20QlikView11.qvw&host...

and see the reports tab. Same file you can find in ur installation path.

Community Browser