Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

if problem

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".

Thanks1.JPG.jpg 

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: if problem

in your load script

load

.....

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

.....

from

     ......;

5 Replies
MVP
MVP

Re: if problem

in your load script

load

.....

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

.....

from

     ......;

Re: if problem

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

mdmukramali
Valued Contributor II

Re: if problem

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.

veidlburkhard
Contributor III

Re: if problem

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

Hi,

You can replace null with zeros.

Look at the attached application.

Regards

ASHFAQ

Community Browser