Urgent help

[n1ef5ng1]

Hi guy,

I have a field call Country where is list out all the countries in the world

For my report, I need to have 20 countries

Therefore my dimension is Country

Expression will by sum with Country and list out the twenty countries that I want

However, I would want the 20 countries to list out the name even if the value is null

I am using personal edition so I cant open any qv file from you guys and I tried using method to uncheck suprress null etc but is not working

Thanks in advance

[alexandros17]

Check show all values in dimension and disable "suppress zero value" checkbox

[n1ef5ng1]

it will list out the whole 244 countries in the world...

However, I only want to list out countries that I listed

[#4]

your list is always the same ?

if yes use a calculated dimension :

if(wildmatch(COUNTRY, 'country1', 'country2', ... 'country20'), COUNTRY)

and you check supress null calues in the dimension tab

[Sokkorn]

Hi,

In your expression, can you use NumSum(Amount) rather than Sum(Amount)? And let me know.

Regards,

Sokkorn

[n1ef5ng1]

This is one of the five expression I am using

=Sum({<
Country={'South Africa','Pakistan','Iran','Saudi Arabia','United Arab Emir'}

,Code={'CL'}
,Class_Name={'Len'}

>} Sales) 

-Sum({<
Country={'South Africa','Pakistan','Iran','Saudi Arabia','United Arab Emir'}

,Code={'RCL'}
,Class_Name={'Len'}
,Status = {'LRSHP'}

>} Sales) 

How to use numsum

[thomas_skariah]

Hi,

You can do condtion in expression like

=Sum({<

Country={'India','New Zealand','UK'}

>} Value)

and in presentation tab

Regards,

Tom

[n1ef5ng1]

As you can see, it only shows 3/5 countries stated

[Sokkorn]

Hi,

Use calculated dimension

=Aggr(Only({1<Country={'South Africa','Pakistan','Iran','Saudi Arabia','United Arab Emir'}>}),Country)

Regards,

Sokkorn

[n1ef5ng1]

I tried, is not working. is still the same result.

however my condition in expression consist of

=Sum({<
Country={'South Africa','Pakistan','Iran','Saudi Arabia','United Arab Emir'}
,Code={'RC'}
,Derived_Class_Name = {'La'}

>} TEU) 

-

Sum({<
Country={'South Africa','Pakistan','Iran','Saudi Arabia','United Arab Emir'}
,Code={'RC'}
,Derived__Class_Name = {'La'}
,Status = {'LHP'}
>} TEU)