Selection dimension sur un graphique

[eprehu]

Est il possible d'affficher seulement les champs qui nous interresse ?

J'utilise la dimension Store channel qui contient tous ces champs mais j'aimerais seulement voir apparaitre E-Commerce et Physical Store.

MErci

[vinieme12]

use set analysis, refer below link

https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/

=sum({<[StoreChannel]={'Physical Store','E-commerce'}>}Value)

[eprehu]

I used this expression and its works.

It is possible on the pie chart, to have the e commerce and all the others on the second part ?

I want to regroup all the field except the e commerce

Thanks.

[vinieme12]

To group your dimension use a calculated dimension

Dimension=if(wildmatch([Store Channel],'Physical Store','E-commerce'),[Store Channel],'Others')

Measure = sum(Something)

[eprehu]

Perfect thanks  a lot!!!!

[vinieme12]

missed to add, this needs to be wrapped in AGGR()

=AGGR( if(wildmatch([Store Channel],'Physical Store','E-commerce'),[Store Channel],'Others'),[Store Channel])