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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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

Labels (1)
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
MVP
MVP

Hi,

one example:

QlikCommunity_Thread_260655_Pic1.JPG

regards

Marco

MarcoWedel
MVP
MVP

Please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

Kushal_Chawda
MVP
MVP

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)