topic Re: if problem in QlikView

if problem

Thu, 19 Jun 2014 09:29:10 GMT

hi everyone!!

i'm working on this data and i've got this column called "yearmonthresolution", but as you can see there are some cells that not contain dates but only a "-". so someone can suggest me what kind of string should i use to replace all the "-" with "open".

Thanks

Re: if problem

maxgro — Thu, 19 Jun 2014 09:33:17 GMT

in your load script

load

.....

if(len(trim(yearmonthresolution))=0, 'open', yearmonthresolution) as yearmonthresolution,

.....

from

......;

Re: if problem

alexandros17 — Thu, 19 Jun 2014 09:35:13 GMT

Ti suggerisco di fare questa operazione nello script per garantire uniformità dei dati:

Quando carichi la tabella contenente il campo yearmonthresolution scrivi:

Load

...

If(IsNull(yearmonthresolution) or trim(yearmonthresolution)='', 'Open', yearmonthresolution) as yearmonthresolution

...

Resident ...

Se il problema non si risolve, significa che fai una join o esiste un'associazione che genera tale situazione, nel caso cerchiamo di trovare un'altra soluzione.

Fammi sapere

Re: if problem

mdmukramali — Thu, 19 Jun 2014 09:36:17 GMT

Dear ,

can you try to load the below table before your table.

Map_Nulls:

Mapping LOAD

NULL(),'open'

AutoGenerate 1;

MAP 'yearmonthresolution' using Map_Nulls;

i hope it will help you.

Thanks,

Mukram.

Re: if problem

veidlburkhard — Thu, 19 Jun 2014 09:40:17 GMT

Hi Gabriele,

I guess this is a straight table. Go to the 'Presentation' tab in the 'Chart Properties' menu and type 'Open' into the 'Null Symbol' check box. That's all.

Hope this helps

Burkhard

Re: if problem

ashfaq_haseeb — Thu, 19 Jun 2014 09:42:13 GMT

Hi,

You can replace null with zeros.

Look at the attached application.

Regards

ASHFAQ