Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
himanshi
Contributor III
Contributor III

calculation based on variable for pivot

Hi Community,

  I have a requirement to get the calculation of a expression based on min and max date variable excluding date selection. please help.

Regards.

2 Solutions

Accepted Solutions
balrajahlawat
Champion
Champion

try like this?

=count(<DateField={"$(= '>=' & date(startdate Variable) & '<=' & date(enddate Variable))"}>} distinct customer)

View solution in original post

himanshi
Contributor III
Contributor III
Author

HI Sunny AND Balraj,

Thanks for the reply this is done.

i have used this for min date : sum({$<[DATE Field] = {"<=$(=vmin)"}>} Inventory)

          and for max date:  sum({$<[DATE Field] = {">=$(=vmax)"}>} Inventory)

Regards,

Himanshi

View solution in original post

3 Replies
sunny_talwar

May be something like this:

=Sum({<Date = {"$(='>=' & Date(vStart) & '<=' & Date(vEnd))"}>}Sales)


Capture.PNG

balrajahlawat
Champion
Champion

try like this?

=count(<DateField={"$(= '>=' & date(startdate Variable) & '<=' & date(enddate Variable))"}>} distinct customer)

View solution in original post

himanshi
Contributor III
Contributor III
Author

HI Sunny AND Balraj,

Thanks for the reply this is done.

i have used this for min date : sum({$<[DATE Field] = {"<=$(=vmin)"}>} Inventory)

          and for max date:  sum({$<[DATE Field] = {">=$(=vmax)"}>} Inventory)

Regards,

Himanshi

View solution in original post