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: 
Not applicable

AGREGATION

  Good morning, please, i need some help on this.

How can i get,  with a table of this kind of data:

    

MARKETSTATE_NAMESum
spainAndalucia1
spainMadrid3
spainValencia5
spainGalicia7
portugalPorto2
portugalLisboa1
portugalSetubal2

Obtein an objct table like this:

 

STATE_NAMESum
Andalucia1
Madrid3
Valencia5
Galicia7
portugal5

Thanks a lot!

Belén

12 Replies
Not applicable
Author

I am trying to do something like this in Dimension..

if ([Market]=('Portugal'),'Portugal',[Region]) and if([Channel]=('on line'),'On line',[Region])

But this not works

Not applicable
Author

Hi,

Thy the below expression as Calculated dimension:

=if(MARKET = 'spain' and Channel <> 'On line', STATE_NAME,if(MARKET <> 'spain' and Channel <> 'On line', MARKET, Channel))

Expression could be Sum(Sum)

Not applicable
Author

Thanks a lot!