Set Help

[Krish2459_58]

Hi,

The below setanlysis is not giving correct data.Could you please help me to find out the issue in below set.

Avg({<[Lease Data Type]={'Current'}>} {$-<[Sublease Data Type]={"*"}>}{$-<[SLRR Data Type]={"*"}>} [Property Code])

Thanks..

[rwunderlich]

Can you explain what you are trying to accomplish? It appears that you want all rows where [Lease Data Type]={'Current'} and then exclude rows that have any value in [Sublease Data Type] or [SLRR Data Type]. Is my understanding correct?

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Krish2459_58]

@rwunderlich , Yes exactly that's what I'm looking.

[Krish2459_58]

The below logic is already written by someone, here I don't understand the "$-".

Avg({<[Lease Data Type]={'Current'}>} {$-<[Sublease Data Type]={"*"}>}{$-<[SLRR Data Type]={"*"}>} [Property Code])

[Gabbar]

Lets Say you have RN as Primary Key. 
Try This Expression :-


Avg({<[Lease Data Type]={'Current'},RN=e({<[Sublease Data Type]={"*"}>+<[SLRR Data Type]={"*"}>})>}  [Property Code])