Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Honored Contributor III

Re: I want to show the value based on user give date

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.

MVP
MVP

Re: I want to show the value based on user give date

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
Community Browser