Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

elimination selection

good morning

I select a zone, but I want in a graph to display all the zones i mean hat how to  eliminate the selection for this graph when zone is the dimension

thank y

5 Replies
sibusiso90
Creator III
Creator III

Morning

Creating a set analysis will be the best way around it

only({1<Zone={'*'}>}Zone)

sum({1<zone=>}zone)

ahaahaaha
Partner - Master
Partner - Master

Hi,

May be like this

Dimension: [FieldZone]

Extension: Sum({1} FieldValue) or Sum({< [FieldZone]=>} FieldValue)


Regards,

Andrey



MarcoWedel

Hi,

one example:

QlikCommunity_Thread_260655_Pic1.JPG

regards

Marco

MarcoWedel

Please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

Kushal_Chawda

You need to exclude your zone selection in set analysis. To do that use below

= Sum ({<Product ={'A'},ZONE=>} Sales)

or

= Sum ({<Product ={'A'},ZONE>} Sales)