New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save \$200. Learn More
Highlighted
Contributor III

expression based on dimension

Can I calculate the expression depending on the Dimension value.

For example is the Country is US I want the sum but if Others I want empty:

So from :

to

Many thanks,

Raphael

1 Solution

Accepted Solutions
Highlighted
MVP

Re: expression based on dimension

Hi Raphael, in this sample can work with this expression:

If(Country = 'US', sum(Score), '')

2 Replies
Highlighted
MVP

Re: expression based on dimension

Hi Raphael, in this sample can work with this expression:

If(Country = 'US', sum(Score), '')

Highlighted

Re: expression based on dimension

May be this?

=If(Country = 'US', Sum(Score), '')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)