Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

MatheusG_Olavo
New 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'

1 Reply
nithin149
New Contributor II

Re: Date variable not working on comparation in set analysis

Try this,

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