Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aniruddhyadutta
New Contributor

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
New Contributor

Re: Variable in the front end

hi..can anyone give me some hints!!

ahaahaaha
Honored Contributor

Re: Variable in the front end

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

Highlighted
Employee
Employee

Re: Variable in the front end

Please try

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

shraddha_g
Honored Contributor III

Re: Variable in the front end

Try this extension Qlik Branch instead

mkelemen
Contributor III

Re: Variable in the front end

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

Community Browser