topic Re: Urgent help in QlikView

Urgent help

n1ef5ng1 — Fri, 31 May 2013 08:00:56 GMT

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

Re: Urgent help

alexandros17 — Fri, 31 May 2013 08:03:06 GMT

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

Re: Urgent help

n1ef5ng1 — Fri, 31 May 2013 08:05:17 GMT

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

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

Re: Urgent help

Fri, 31 May 2013 08:07:50 GMT

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

Re: Urgent help

Sokkorn — Fri, 31 May 2013 08:08:15 GMT

Hi,

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

Regards,

Sokkorn

Re: Urgent help

n1ef5ng1 — Fri, 31 May 2013 08:11:24 GMT

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

Re: Urgent help

thomas_skariah — Fri, 31 May 2013 08:13:14 GMT

Hi,

You can do condtion in expression like

=Sum({<

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

>} Value)

and in presentation tab

Regards,

Tom

Re: Urgent help

n1ef5ng1 — Fri, 31 May 2013 08:16:27 GMT

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

Re: Urgent help

Sokkorn — Fri, 31 May 2013 08:18:37 GMT

Hi,

Use calculated dimension

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

Regards,

Sokkorn

Re: Urgent help

n1ef5ng1 — Fri, 31 May 2013 08:20:05 GMT

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)

Re: Urgent help

Fri, 31 May 2013 08:22:16 GMT

DID YOU UNCHECK suppress missing in the presentation tab ?

Re: Urgent help

n1ef5ng1 — Fri, 31 May 2013 08:23:42 GMT

Why is it -

Re: Urgent help

Sokkorn — Fri, 31 May 2013 08:26:54 GMT

Hi,

Follow this

1. Create one Straight Table

2. Create one calculated dimension

=Aggr(Only({<

Country={'South Africa','Pakistan','Iran','Saudi Arabia','United Arab Emir'},Code={'RC'},Derived_Class_Name = {'La'}>} Country),Country)

3. Create expression: Sum(TEU)-Sum({$<Status = {'LHP'}>} TEU)

Regards,

Sokkorn

Re: Urgent help

n1ef5ng1 — Fri, 31 May 2013 08:30:18 GMT

i did that too...

Re: Urgent help

n1ef5ng1 — Fri, 31 May 2013 08:35:42 GMT

It doesn show all too. It eliminate those countries with empty field too. anyway this is different month report, thats why it shows 1 out of 5 countries rather than previously 3/5 countries

Re: Urgent help

n1ef5ng1 — Fri, 31 May 2013 08:37:06 GMT

Tried with straight table too, same result ;(

Re: Urgent help

tresB — Fri, 31 May 2013 08:40:07 GMT

if you use SET analysis in expression, the unrelated countries get filtered out there, so it won't come up in the dimension. you have to use Sum(If( ..... in your expression .

Re: Urgent help

Sokkorn — Fri, 31 May 2013 08:43:39 GMT

Ok. Can you share your app?

Re: Urgent help

n1ef5ng1 — Fri, 31 May 2013 08:48:00 GMT

sorry but how do i use sum(if( when my code have so many comma,

=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)

terribly sorry, abit newbieo to QV

Re: Urgent help

n1ef5ng1 — Fri, 31 May 2013 08:48:35 GMT

Ok but how do i share without data/