topic Re: What is wrong? in QlikView

What is wrong?

Anonymous — Tue, 11 Aug 2015 08:50:40 GMT

Hi Experts,

I have a very simple set analyis which is not working.

=Count({$<%ERDAT ={$(=max(%ERDAT))}>} Delivery.MATKL)

Can you please let me know what is wrong with this?

Regards

Jeba

Re: What is wrong?

lironbaram — Tue, 11 Aug 2015 08:52:11 GMT

=Count({$<%ERDAT ={'$(=max(%ERDAT))'}>} Delivery.MATKL)

Re: What is wrong?

sunny_talwar — Tue, 11 Aug 2015 08:52:19 GMT

Try this may be:

=Count({$<[%ERDAT] ={"$(=max([%ERDAT]))"}>} Delivery.MATKL)

Re: What is wrong?

oknotsen — Tue, 11 Aug 2015 08:55:56 GMT

Some symbols and the use of spaces can cause problems.

You can usually bypass these by either not using those or putting the parts with spaces and symbols in square brackets.

Re: What is wrong?

Anonymous — Tue, 11 Aug 2015 09:00:53 GMT

Hi Liron and Sunny,

Still its not working

42224 is the output in the textbox when I use max(%ERDAT).fyi.

Regards

Jeba

Re: What is wrong?

sunny_talwar — Tue, 11 Aug 2015 09:03:14 GMT

Is %ERDAT a date field??? If it is then try this:

=Count({$<[%ERDAT] ={"$(=Date(Max([%ERDAT]), 'DateFieldFormatHere'))"}>} Delivery.MATKL)

Re: What is wrong?

Anonymous — Tue, 11 Aug 2015 13:34:08 GMT

Hi Sunny,

Still no success.

Count({$<[%ERDAT] ={"$(=Date(Max([%ERDAT]), 'MM/DD/YYYY'))"}>} Delivery.MATKL)

May be you can help me in alternative way if I provide my requrirements.

I am designing a NPrinting report with a straight table.Hence my straight table shoule always have yesterdays data(based on ERDAT).On Mondays it should consider Friday's date.

Is there a easy way other than the above set analysis?

Thanks & Regards

Jeba

Re: What is wrong?

Anonymous — Tue, 11 Aug 2015 13:42:13 GMT

if you want last day (friday when max(ERDAT)=monday) you Need to use

=FirstWorkDate(max(%ERDAT),2)

try this

Count({$<[%ERDAT]={'=$(=FirstWorkDate(max(%ERDAT),2))'}>}Delivery.MATKL

Re: What is wrong?

Anonymous — Tue, 11 Aug 2015 13:47:56 GMT

Hi Rudolf,

Thanks for the guidance.

Initially I was trying the same expression and it didn't worked.

Now I am trying to achive the count based on maxdate and then using the Firstwork date.

Unfortunately both are not working

Regards

Jeba

Re: What is wrong?

Anonymous — Tue, 11 Aug 2015 13:48:19 GMT

Hi,

Maybe try this:

=Count({$<[%ERDAT] ={"$(=Date(Max([%ERDAT]),'MM/DD/YYYY'))"}>} Delivery.MATKL)

Re: What is wrong?

Anonymous — Tue, 11 Aug 2015 13:59:15 GMT

Hi Neetha,

It seems some other problem with the data I have.

Because you experts have provided many answers which are correct,but nothing worked.

Regards

Jeba

Re: What is wrong?

Anonymous — Tue, 11 Aug 2015 14:02:24 GMT

Hi,

check with date format