topic Help with a SET in QlikView

Help with a SET

Tue, 21 Feb 2012 08:14:07 GMT

Would really value if someone can help me with this set. When I mark the year (fieldname Year) and month (fieldname Month) I get the result as in the first picture. What I want is a set-expression that distinct count the ID-field but only the ones that are releated to Enddate. In the lower pic I have manually marked the enddate in that way I would like the set to do.

/Thanks!

Help with a SET

jagan — Tue, 21 Feb 2012 08:20:06 GMT

Hi,

Try this expression

=Count({<EndDate=P(EndDate)>} DISTINCT ID)

Hope this helps you. Can you attach the sample file.

Regards,

Jagan.

Help with a SET

Tue, 21 Feb 2012 08:38:33 GMT

Thanks. I´d also tried this,

=Count(({$<Enddate=P({1<ID={">1"}>}Enddate)>}ID)

It gave me the same result as yours but aint as nice as yours and can´t hold Distinct.

Help with a SET

CELAMBARASAN — Tue, 21 Feb 2012 08:45:57 GMT

Hi,

Try something like this

=Count({<EndDate={$(=Chr(39)&Concat(Distinct EndDate ,Chr(39) & ',' & Chr(39)) & Chr(39))}>} DISTINCT ID)

Celambarasan

Help with a SET

Tue, 21 Feb 2012 09:04:11 GMT

Hi Celambarasan, thanks. That also works. What does the (=Chr(39)&Concat(Distinct EndDate ,Chr(39) & ',' & Chr(39)) & Chr(39) means?

Help with a SET

CELAMBARASAN — Tue, 21 Feb 2012 09:12:46 GMT

Hi,

It just replaces the selected date in single quotes like

{'2011-12-30','2011-12-31'}

Chr(39) is single quotes(')

Celambarasan