Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aniruddhyadutta
Creator
Creator

Variable in the front end

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

variable.PNG

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.

variable.PNG

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

5 Replies
aniruddhyadutta
Creator
Creator
Author

hi..can anyone give me some hints!!

ahaahaaha
Partner - Master
Partner - Master

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

Clever_Anjos
Employee
Employee

Please try

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

shraddha_g
Partner - Master III
Partner - Master III

Try this extension Qlik Branch instead

mkelemen
Creator III
Creator III

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