set analysis with > symbol in the field value

[ronaldwang]

I have a filed name days to pay with the below four possible values:

>60 days, no date, 30 days, 60 days as possible value

And when I use in set analysis

Sum({$<[days to pay]={“30 days”}>} amount) will work

But Sum({$<[days to pay]={“>60days”}>} a unt) will work

  Any idea ?

[Anil_Babu_Samineni]

What is the issue? You said, 2 expressions working

[effinty2112 · Accepted solution]

Hi Ronald,

I think the problem lies with the > character in the dimension value >60 days. Enclosing this in double quotes will tell QlikView to look at the inequality greater than the text "60 days" rather than where the dimension value equals '>60 days'.

Try using single quotes instead.

Sum({$<[days to pay]={'>60days'}>} amount)

good luck

Andrew

[sunny_talwar]

You can also try this

Sum({$<[days to pay] = {“=Only({1} [days to pay]) = '>60days' ”}>} a unt)

[pradosh_thakur]

QlikView accepts the three syntax for text. You may write:

{<[days to pay]={">60days"}>}

if its not working then

{<[days to pay]={'>60days'}>}

{<[days to pay]={[>60days]} >}

regards

Pradosh