Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

4 Replies
Not applicable
Author

Hi,

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

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

Please check attached file.

MayilVahanan

Hi

Try like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

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.