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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I want to show the value based on user give date

Hi Friends,

I wanna show the Sales value or calculate the sum of sales based on user date inputs

sale.PNG

This is the table for your ref.....

2 Replies
sujeetsingh
Master III
Master III

Use a n Input Box. this will let the user to enter the values he want.

Now you use calculated dimension with if condition as where Sales >= the Value entered by user in input box.

jonathandienst
Partner - Champion III
Partner - Champion III

Assuming you load the dates as valid QV dates, then in a text box:

     =Sum({<Date = {">=$(=vMinDate) <=$(=vMaxDate)"}>} Sales)

The exact expression will depend on how the Date field and the two variables are defined and formatted.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein