Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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