Set Analysis comparing field to "right" 2 of other field

[zagzebski]

I must have something wrong in my expression because the chart just gives me the sum of revenue for all records - it is not evaluating the set.

Sum({<[Renewal Month]={"=Right([Incurred Year Month],2)"}>} [Revenue])

Thanks in advance.

[#2]

Would it be possible for you to share a sample qvw?

[Jason_Michaelides · Accepted solution]

Try:

Sum({<[Renewal Month]={"$(=Right([Incurred Year Month],2))"}>} [Revenue])

[Nicole-Smith]

Sum({<[Renewal Month]={'=[Renewal Month]=Right([Incurred Year Month],2)'}>} [Revenue])

[zagzebski]

Thanks!. I am always confused as to when to use the $ sign expansion. Not sure why in this case...

[antoniotiman]

Set Analysis is not per Row.

Use if

Sum(If([Rev Month]=Right([Inc YM],2),Revenue)

Regards

[zagzebski]

Thanks Nicole -

The help I received from Jason (above) had this on the right side of the expression:

{"$(=Right([Incurred Year Month],2))"}

Yours had this:

{'=[Renewal Month]=Right([Incurred Year Month],2)'}

Both worked fine bhut I am not sure I totally understand why!

[zagzebski]

Jason - I have a slight modification to what I need.

I need the formula to be LESS than or = . I added it below but then I get no results. Is it not as simple as what I did below?

Sum({<[Renewal Month]={"$(<=Right([Incurred Year Month],2))"}>} [Revenue])

[jerem1234]

Sum({<[Renewal Month]={"<=$(=Right([Incurred Year Month],2))"}>} [Revenue])

Should do it.

Hope this helps!

[Thsmi_]

Hi, I'm new to qlik sense. may i know, what does it mean by Right([Incurred Year Month],2) in Sum({<[Renewal Month]={'=[Renewal Month]=Right([Incurred Year Month],2)'}>} [Revenue])?