topic Re: Need Help in QlikView

Need Help

paulwalker — Mon, 16 Feb 2015 14:54:09 GMT

Hi All,

is there any error..??

=count({<Flag={'Opened'}>}, daysDate={{<Flag={'Closed'}>}'$(=Max(Date))'}>} CountID))

Anonymous — Mon, 16 Feb 2015 14:58:13 GMT

There are errors. Can you explain in words what you're trying to do?

Mon, 16 Feb 2015 15:00:26 GMT

Hi Paul,

The syntax of the set analysis you are using is wrong.

First define a variable :

Defining a variable:

vdaysDate = Max({<Flag={'Closed'}>}daysDate)

It should be

=count({<Flag={'Opened'},Name={'Test Report'}, daysDate={'$(vdaysDate)'}>} CountID)

Hope this helps.

Regards

maxgro — Mon, 16 Feb 2015 15:02:00 GMT

yes,some errors

=count({<Flag={'Opened'}>}{<Name={'Test Report'},............

this should be correct

=count({<Flag={'Opened'},Name={'Test Report'},........

but after that it's difficult to understand your requirement

Anonymous — Mon, 16 Feb 2015 15:49:50 GMT

Strangely, a couple of my responses disappeared, together with your replies(?)
Repeating:

I assume you want to count the records for which Name='Test Report' and
either
Flag='Opened'
or
Flag='closed' and daysDate is the latest date.

If so, try:

count({<Name=}'Test Report'}> * (<Flag={'Opened'}> + <Flag={'Closed'}, datesDate={"$(=date(max(datesDate)))"}>)}CountID)