Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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)