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: 
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)