topic Re: Auto selected dates in QlikView

Auto selected dates

gidon500 — Sun, 14 Aug 2016 07:15:32 GMT

Hi guys

i have a rquest that i could not fulfil

enclosed is qvw file with sales and date

the customers to select only one date from the list box

and get all data from the min date , to the selected date .

can we make it

thanks

gidon

kaushiknsolanki — Sun, 14 Aug 2016 07:38:31 GMT

Hi,

Make Straight Table and Put DOCDATE as dimension and

Sum({<DOCDATE = {"<=$(=Date(max(DOCDATE)))"}>}AMOUNT)

As expression.

Regards,

Kaushik Solanki

vinieme12 — Sun, 14 Aug 2016 07:42:07 GMT

i Think this is enough as we'll be comparing with value from same field

Sum({<DOCDATE = {"<=$(=max(DOCDATE))"}>}AMOUNT)

kaushiknsolanki — Sun, 14 Aug 2016 07:55:19 GMT

Hi,

Its because the date format matters in set analysis.

Regards,

Kaushik Solanki

gidon500 — Sun, 14 Aug 2016 08:20:12 GMT

thanks

gidon

vinieme12 — Sun, 14 Aug 2016 08:40:12 GMT

Works in the above case