topic Set Analysis used Variable Date type in QlikView

Set Analysis used Variable Date type

Tue, 19 Feb 2013 08:41:51 GMT

Hi,

I should cont iun a table(filtering on a range date) how many WELDID thatere are before range selected.

I use

=COUNt({$<DTES_VT = {<$(#FDate2)}>} WELDID)

but i have an error..

Please someone can help me?

many thanks 🙂

Re: Set Analysis used Variable Date type

khadeer — Tue, 19 Feb 2013 08:46:27 GMT

Can u post ur sample data

Re: Set Analysis used Variable Date type

alexandros17 — Tue, 19 Feb 2013 08:47:36 GMT

COUNT({$ <DTES_VT = {<'$(FDate2)'}>} WELDID)

Try this but it would be better if you could tell me the error message

Re: Set Analysis used Variable Date type

sushil353 — Tue, 19 Feb 2013 08:52:33 GMT

Try this

=COUNt({$<DTES_VT = {"<$(#FDate2)"}>} WELDID)

Re: Set Analysis used Variable Date type

jonathandienst — Tue, 19 Feb 2013 09:12:30 GMT

Assuming that FDate2 is a variable that contains a date value, and DTES_VT is a field containing a date in the default format for your document, then this should work:

Count({<DTES_VT = {"<$(=Date(FDate2))"}>} WELDID)

If FDate2 is a field, then you could use something like

Count({<DTES_VT = {"<$(=Date(Max(FDate2)))"}>} WELDID)

But your mileage will depend on your data model. I suggest that if these two don't work, that you post your document or at least a sample.

Regards

Jonathan

Re: Set Analysis used Variable Date type

Tue, 19 Feb 2013 09:16:15 GMT

thanks everybody 🙂

i missed the " char to open and close the condition!

many thanks and best regards!