Variable in the front end

[aniruddhyadutta]

Hi all,

I am trying to provide a variable box in the front end where user can input date manually.

Ist step:

I drag a variable object in the front end

2nd step:

I tried to create a variable which I can bind with the variable to fetch the max date by default.

LASTDT:

LOAD max(DATETIME) as LASTDT

RESIDENT INPROCESS_FINAL_TABLE;

LET vDATE = LEFT(Peek('LASTDT',0,'LASTDT'),8);

//LET vDATE =Date(Date#(Peek('LASTDT',0,'LASTDT'),'MMDDYYYYHHMMSS'),'YYYY-MM-DD');

its working and I am getting my variable text box populated with the max date.

but the issue is when I put some other date the set analysis expression is not working which is as below:

Count({$<Dates_IP={'$(=(Date(Date#('$(vDATE)','YYYYMMDD'),'YYYY-MM-DD'))'},PROC_STATUS = {'success'},DIRECTION_IP={'I'},SERVER_NAME_IP={'SBI_Dev_All_Nodes'}>}CORE_ID_IP)

can some plz help me!!

Thanks in advacnce

[aniruddhyadutta]

hi..can anyone give me some hints!!

[ahaahaaha]

Search for items enclosed in braces, always determined using double quotes. Maybe this?

[Clever_Anjos]

Please try

{"$(=(Date(Date#('$(vDATE)','YYYYMMDD'),'YYYY-MM-DD'))"}

[shraddha_g]

Try this extension Qlik Branch instead

[mkelemen]

Hi,

I think the problem is that you have different date formats

MMDDYYYY in the box

YYYYMMDD in the expression

try putting 20161229 in the box - if it works then you need to fix the formatting

BR,

  Matus