topic Re: Variable is not working properly in QlikView

Variable is not working properly

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have two Variable varMinDate and varMaxDate.

These two are not showing proper date right after reloading (default view).

But if we select any date then it is showing correct date.

Can anyone please help me on this.

Thanks,

Sarif

MK9885 — Thu, 27 Sep 2018 18:37:47 GMT

maybe user Date(your field) then save the variable?

or Date(YOURDATEFIELD,'MM/DD/YYYY') store into variable

mhmmd_srf — Fri, 28 Sep 2018 13:01:02 GMT

I need to capture this through variable not Date field.

MK9885 — Fri, 28 Sep 2018 13:03:49 GMT

Yes but to store a variable you'll write an expression in variable right?

What is the expression in your variable?

mhmmd_srf — Fri, 28 Sep 2018 13:37:12 GMT

This is my expression for creating variable:

Temp:

Load

Date(min(ShipDate1)) as minDate,

Date(max(ShipDate1)) as maxDate

Resident FACT_PROOFOFDELIVERY;

Let varMinDate = Date(Peek('minDate', 0, 'Temp'));

Let varMaxDate = Date(Peek('maxDate', 0, 'Temp'));

MK9885 — Fri, 28 Sep 2018 14:00:25 GMT

Your varMinDate and MaxDate are stored in numbers like 4524

To test that take a text box and type in your variable

=$(varMinDate ) ans you'll see the dates come as just numeric format

Below I have same variable...

On left it is just

=$(varMinDate ) and on right it is Date($(varMinDate ))