Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mgavidia
Not applicable

Need help involving date field in set analysis expression

Hello everyone,

I hope someone in the community is able to assist me with this problem.

I need to come up with an expresion that will give me the total count of records where:

-     UnitStatus is "Rented'

-     Category is either RV" or "Office spaces"

-     MoveOutDate is blank (that is, there is no date stored in the field. It is a 'date' field)

This expression below gives me the first 2 requirements but I cannot come up with the right expression for the date.

How can this Set Analysis expression by modified to tell QlikView to also exclude records where the date is blank?

Sum ({$<UnitStatus={'Rented'},Category={"RV*","Office Spaces"}>}#MoveInCounter)

I'll appreciate any tips on this matter.

Thanks,

Miguel Gavidia

2 Replies
jagan
Not applicable

Re: Need help involving date field in set analysis expression

Hi,

Try this

=Sum ({$<UnitStatus={'Rented'},Category={"RV*","Office Spaces"}, MoveOutDate-={'*'}>}#MoveInCounter)

Qlikview shows error new -=, but it works as expected.


Hope this helps you.

Regards,

Jagan.

mgavidia
Not applicable

Re: Need help involving date field in set analysis expression

Jagan,

Well, I did try that previously ( * with double quotes) and it gave me all 0s.

That's why I think I am using the wrong syntax. I cannot find any samples of set analysis using dates in this way...

I also tried Stefan's set analysis wizard but no luck.

=Sum ({$<UnitStatus={'Rented'},Category={"RV*","Office Spaces"}, MoveOutDate-={"*"}>}#MoveInCounter)

Thanks for your reply.

Miguel