Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.

Labels (1)
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
MVP
MVP

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.