Qlik Community

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
r20017aaa
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 :

2018-01-08_09-48-31.bmp

to

2018-01-08_11-41-08.bmp

Many thanks,

Raphael

1 Solution

Accepted Solutions
Highlighted

Re: expression based on dimension

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

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

View solution in original post

2 Replies
Highlighted

Re: expression based on dimension

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

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

View solution in original post

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)