Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
jsobrinho
Creator
Creator

Improve Set analysis logic

Hi team,

Could you please, help me improve the set analysis:    


if(GetSelectedCount(Country)>=1 and GetSelectedCount([Type])>=5,

if(ID=1

FirstSortedValue({<Type={"$(vType5)"},Country={"$(vCountry1)"}>}Value1, -Total),

FirstSortedValue({<Type={"$(vType5)"},Country={"$(vCountry1)"}>}Value2, -Total),


if(GetSelectedCount(Country)>=5 and GetSelectedCount([Type])>=1,

if(ID=1

FirstSortedValue({<Type={"$(vType1)"},Country={"$(vCountry5)"}>}Value1, -Total),

FirstSortedValue({<Type={"$(vType1)"},Country={"$(vCountry5)"}>}Value2, -Total),

if(GetSelectedCount(Country)>=2 and GetSelectedCount([Type])=4,

if(ID=1

FirstSortedValue({<Type={"$(vType1)"},Country={"$(vCountry2)"}>}Value1, -Total),

FirstSortedValue({<Type={"$(vType1)"},Country={"$(vCountry2)"}>}Value2, -Total),

),

)


Its possible improve this logic?


Labels (2)
0 Replies