Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
MatheusG_Olavo
Contributor
Contributor

Date variable not working on comparation in set analysis

Hi all,

 

I'm new to ClikView and I would like your help to solve a problem.

 

  • I created a variable of Data like this:

variable1 = Date('expression',  'DD/MM/YYYY hh:mm:ss')

  • When I try to use this variable to compare with another data (VCTPRO) in set analysis it doesn't work, even though they are the same:

min({<VCTPRO = {$(variable1 )}>} VALOR_PARCELA)

  • But if I go to the variable and put it manually, it works fine:

variable1 = '2018-12-27 00:00:00'

  • What am I doing wrong? I need the expression on the variable, I can't just use one manually, it will chenge wich time.

Obs.: The format of VCTPRO  is 'DD/MM/YYYY HH:mm:ss'

Labels (4)
1 Reply
nithin149
Contributor II
Contributor II

Try this,

min({<VCTPRO = {'$(variable1)'}>} VALOR_PARCELA)