topic Re: Applying Images in Set Analysis? in QlikView

Applying Images in Set Analysis?

Tue, 07 Jul 2015 14:51:23 GMT

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.

Re: Applying Images in Set Analysis?

Clever_Anjos — Tue, 07 Jul 2015 14:52:40 GMT

Today() is not a valid field

Re: Applying Images in Set Analysis?

MK_QSL — Tue, 07 Jul 2015 14:55:37 GMT

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

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

Re: Applying Images in Set Analysis?

richard_chilvers — Tue, 07 Jul 2015 14:57:38 GMT

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.

Re: Applying Images in Set Analysis?

Tue, 07 Jul 2015 15:07:11 GMT

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.

Re: Applying Images in Set Analysis?

MK_QSL — Tue, 07 Jul 2015 15:09:12 GMT

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

Re: Applying Images in Set Analysis?

Tue, 07 Jul 2015 15:17:48 GMT

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.

Re: Applying Images in Set Analysis?

MK_QSL — Tue, 07 Jul 2015 15:25:25 GMT

Like this?

Re: Applying Images in Set Analysis?

Tue, 07 Jul 2015 15:28:53 GMT

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..

Re: Applying Images in Set Analysis?

MK_QSL — Tue, 07 Jul 2015 15:30:46 GMT

Have you checked attachment from my previous answer?

Re: Applying Images in Set Analysis?

Tue, 07 Jul 2015 15:32:13 GMT

No Manish.. Where can I get it..

Re: Applying Images in Set Analysis?

MK_QSL — Tue, 07 Jul 2015 15:39:38 GMT

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

It is something like

Re: Applying Images in Set Analysis?

Tue, 07 Jul 2015 15:42:44 GMT

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

Re: Applying Images in Set Analysis?

MK_QSL — Tue, 07 Jul 2015 15:45:18 GMT

Click on

Applying Images in Set Analysis?

Re: Applying Images in Set Analysis?

Tue, 07 Jul 2015 15:52:27 GMT

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.

Re: Applying Images in Set Analysis?

MK_QSL — Tue, 07 Jul 2015 15:57:51 GMT

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