Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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
@rwunderlich , Yes exactly that's what I'm looking.
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])
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])