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.

[Clever_Anjos]

Today() is not a valid field

[MK_QSL]

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

or

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

[richard_chilvers]

Hi

1) I'm not an expert but I think in your set analysis, you must have [Shipped Date] ={ .... } instead of your way round.

2) To display an image, go to Properties>Expressions> and Display Option> Representation must be set to Image.

[#5]

Hi Manish,

The Expression say Ok. But the value seems to be equal for shipped date. For Example: Shipped Date = 10-07-2015

Now if today's Date is 07-07-2015.So I need to put a Red Mark to say that the date is approaching.so I need something like shipped date - 3 means show red mark..

Before trying above I was trying to get the sum (order total) so that we can trying getting the second task as Richard has put. go to Properties>Expressions> and Display Option> Representation must be set to Image.

[MK_QSL]

Provide sample data or sample app with your expected result in excel file.

[#7]

Order ID	Year	Order Date	Employee ID	Status	Customer Name	Product ID	Shipped Date	Shipping Fee	Taxes	Order Total
30	2011	01-07-2015	Anne Hellung-Larsen	Open	Company AA	1167	10-07-2015	Rs. 200.00	Rs. 0.00	Rs. 1,705.00

Here when you see the shipping date is 10-07-2015 So today's date is 07-07-2015..Since the outcome is Shipping Date - 3 days,I need to display the Order total.. Actually I wanted to show some Red Mark symbol to indicate that the date is approaching But I would like to try this first.

[MK_QSL]

Like this?

[#9]

Hi,

This is the Input file. I am trying the output in a straight table to test it .I am creating a kind of KPIs..

[MK_QSL]

Have you checked attachment from my previous answer?