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

Conditional View

H=i there, 
How do I make a Treemap chart show data if formula below is fulfilled?
Using: 
add-ons
Data Handling
Calculation condition

There I am adding formula: 
=Count({<apsys_item & apsys_name={'>'}>} apsys_item & apsys_name) > 0

This is giving me error.
Any suggestions?
Thanks a million!

Labels (1)
  • Chart

5 Replies
379SSS
Contributor III
Contributor III

Hi @JoseGarcia ,

What exactly you're trying to calculate?

JoseGarcia
Creator III
Creator III
Author

hi this is the measure:

if ( $(vConditionFlag) ,
COUNT({<apsys_cat_score={'Cat1'},
apsys_sub_item={'Global'},
flag_apsys_last_image={1}>} distincT apsys_site)
,

COUNT({<apsys_cat_score={'Cat1'},
apsys_sub_item={'Global'},
apsys_id_period={'=$(v_Max_COD_APSYS)'}
>}distincT apsys_site)

)

JoseGarcia
Creator III
Creator III
Author

also trying:
Count({<apsys_item_id={'='}>} TOTAL <apsys_item_id> {<apsys_score={'<1'}>} apsys_score)

But not luck 😞

JoseGarcia
Creator III
Creator III
Author

not 100% sure, if adding formula in the correct section?

JoseGarcia_0-1695365832289.png

 

JoseGarcia
Creator III
Creator III
Author

@379SSS , 

post it messages above.
Any suggestion?

Thanks