Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Krish2459_58
Creator
Creator

Setanalysis logic correction

Hi,

Please suggest any other way to simplyfy  the the below setanalysis.

 

//gives properties with no leases
Avg(
{$-<[Lease Data Type]={"*"}>}
[Property Code])
+
//gives properties with leases but only by current lease data type with Rent Reviews and no Subleases
Avg(
{<
[Lease Data Type]={'Current'},
[Property Data Type]={'Current'},
[LRR Data Type]={'Current'}>}
{$-<[Sublease Data Type]={"*"}>}
{$-<[SLRR Data Type]={"*"}>}
[Property Code])

 

Thanks..

Labels (1)
1 Reply
Chanty4u
MVP
MVP

Try this 

Avg(

    {<

        [Property Data Type] = {'Current'},

        [LRR Data Type] = {'Current'},

        [Lease Data Type] = {"*"} - {'Current'},

        [Sublease Data Type] = {"*"},

        [SLRR Data Type] = {"*"}

    >} [PropertyCode]

)