topic Re: Variables in set analysis is not working in QlikView

Variables in set analysis is not working

Wed, 25 Nov 2020 16:16:04 GMT

I have scenario,

I have data upto next 20 years from last couple of years

Example my database is from

2005-01-01 to 2016-09-01(current month) and i am adding next 20 years data i.e.2036-09-01

i want to show database max value sales like below

sum({<Date = {$(V_DB_Max_date)}>} Sales)

here Date is number format

If i give sum({<Date = {42614}>} Sales) it is working fine

Please do the needful

Thanks

Thiru

sunny_talwar — Mon, 26 Sep 2016 07:58:52 GMT

Try this may be:

Sum({<Date = {$(=V_DB_Max_date)}>} Sales)

Sum({<Date = {$(=$(V_DB_Max_date))}>} Sales)

Anonymous — Mon, 26 Sep 2016 08:10:03 GMT

Hi Thiru, try this

sum({<Date = {$(=Date(V_DB_Max_date))}>} Sales)

Regards!