topic Re: problem with set analysis in QlikView

problem with set analysis

Anonymous — Fri, 17 Jan 2014 02:38:25 GMT

Hi community,

I have a problem with set analysis, it give me 0 where I'm sure it not the right one. Anyone help me please with this error

Sum({<DocDate={$(SelectDate)}>} Amount)

-H

jagan — Fri, 17 Jan 2014 02:41:03 GMT

Hi,

Try this

=Sum({<DocDate={'$(=SelectDate)'}>} Amount)

Regards,

Jagan.

Sokkorn — Fri, 17 Jan 2014 02:43:15 GMT

Hi H,

It look like you use variable in set analysis. Can you confirm:

1. SelectDate is a field name or variable? If variable, what is definition?

2. What is DocDate value look like? In Date format or number?

You may try Sum({<DocDate={"$(SelectDate)"}>} Amount)

Regards,

Sokkorn

Anonymous — Fri, 17 Jan 2014 02:44:52 GMT

Jagan,

Still 0 value

-H

Anonymous — Fri, 17 Jan 2014 02:46:45 GMT

Sok,

0 value too. And yes, SelectDate is a variable. SelectDate=Max(DocDate) and DocDate is a date format.

-H

Sokkorn — Fri, 17 Jan 2014 02:49:30 GMT

Hi H,

Ok, got your point. Do this way

=Sum({<DocDate = {"$(=Date(Max(DocDate),'DD.MM.YYYY'))"} >} Sales)

Edit: you need to format date according to your DocDate field.

Regards,

Sokkorn

Anonymous — Fri, 17 Jan 2014 02:59:06 GMT

Sok, Jagan - Thank you so much. It work.

-H