Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use set analysis, refer below link
https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/
=sum({<[StoreChannel]={'Physical Store','E-commerce'}>}Value)
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.
To group your dimension use a calculated dimension
Dimension=if(wildmatch([Store Channel],'Physical Store','E-commerce'),[Store Channel],'Others')
Measure = sum(Something)
Perfect thanks a lot!!!!
missed to add, this needs to be wrapped in AGGR()
=AGGR( if(wildmatch([Store Channel],'Physical Store','E-commerce'),[Store Channel],'Others'),[Store Channel])