Skip to main content
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