topic calculation based on variable for pivot in QlikView

calculation based on variable for pivot

himanshi — Tue, 16 Feb 2016 07:32:58 GMT

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.

sunny_talwar — Tue, 16 Feb 2016 10:00:29 GMT

May be something like this:

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

Anonymous — Tue, 16 Feb 2016 10:06:23 GMT

try like this?

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

himanshi — Tue, 16 Feb 2016 11:28:59 GMT

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