Applying Images in Set Analysis?

[#1]

Hi,

I am trying to achieve a requirement. When the status is "Open" and if the Shipped Date is approaching. I would like show red mark for if the Current Date is [Shipped Date] - 3.

First I am trying to get the output for the below expression and I am getting Set identifier error.

=Sum({$<Status={Open}, Today()={[Shipped Date]- 3}>}[Order Total])

Secondly, I would like to show a  red mark which I took from Images in Expressions tab ='qmem://<bundled>/BuiltIn/led_r.png'.How can I apply Images in the above expression in Straight table.

[#2]

No Manish.. Where can I get it..

[MK_QSL · Accepted solution]

Check my all reply. You will find at one of my reply...

It is something like

[#4]

I am not getting it..I can see one reply "like this?". . Can you paste it here.

[MK_QSL]

Click on

Applying Images in Set Analysis?

[#6]

As I am using personal Edition, my 5 attempts have gone..I Would not be able to open the qvw file..But the captured Image is what Exactly I needed.. Can you send me the expression or steps so that I can replicate here.

[MK_QSL]

For Showing Value

SUM({<[Shipped Date] = {'$(=Date(Today()+3))'}>}[Order Total])

Add extra fields in set analysis whatever you want to add

For Image

IF([Shipped Date] = Date(Today()+3), 'qmem://<bundled>/BuiltIn/led_r.png', 'qmem://<bundled>/BuiltIn/led_g.png')

Representation

Image

Image Formatting

Keep Aspect