topic Re: Problem in Split one filed into two fileds with in Load Script in QlikView

Problem in Split one filed into two fileds with in Load Script

Thu, 30 Jul 2015 15:03:01 GMT

Hi Frnz,

I want some data in AMID_ID filed. so i have taken AMID from AMID_ID by using some condition. It is not working, something problem in load script. Please find the attached QVW.

Re: Problem in Split one filed into two fileds with in Load Script

antoniotiman — Thu, 30 Jul 2015 15:12:39 GMT

Which is Your AMID when AMID_ID is equal to 'zzz1' or 'zzz2' and so on ?

Re: Problem in Split one filed into two fileds with in Load Script

Qrishna — Thu, 30 Jul 2015 15:18:11 GMT

modify your expression in script as

if(wildmatch(AMID_ID,'zzz*')<>1,AMID_ID)

output:

Re: Problem in Split one filed into two fileds with in Load Script

Anonymous — Thu, 30 Jul 2015 15:20:43 GMT

in your textobject for AMID you Need to include only the values and not the nulls

using set Analysis will do it

if you use other Charttypes you Need to define "suppress null values" under presentation

=sum(aggr(sum({<AMID={'*'}>}Sale),AMID))

Re: Problem in Split one filed into two fileds with in Load Script

Fri, 31 Jul 2015 05:27:57 GMT

Hi Frnz, Thaks for your answers. Actually I would like to modify in script level only. When i filter 'ZZZ' acount ids, AMID field value contains Null values. So results came differently. Please find the attached QVW, you will get idea in this. In bar chart values are coming wrongly. So i have to change in script level to get exact results

Re: Problem in Split one filed into two fileds with in Load Script

sasiparupudi1 — Fri, 31 Jul 2015 05:44:31 GMT

may be

if(not WildMatch (AMID_ID,'zzz*'),AMID_ID,'z') as AMID

Re: Problem in Split one filed into two fileds with in Load Script

Fri, 31 Jul 2015 05:54:54 GMT

Hi Sasidhar,

I just tried it is not working. AMID field contains null values after filtered. How can we remove null in this?

Re: Problem in Split one filed into two fileds with in Load Script

sasiparupudi1 — Fri, 31 Jul 2015 06:07:33 GMT

if(not WildMatch (AMID_ID,'zzz*'),AMID_ID,'na'&Right(AMID_ID,1)) as AMID

Re: Problem in Split one filed into two fileds with in Load Script

Ralf-Narfeldt — Fri, 31 Jul 2015 06:13:59 GMT

I don't see what you mean. If you use Sasidhar's example AMID will get a 'z' value for each value that matches WildMatch (AMID_ID,'zzz*'). You can of course change 'z' to anything you like.

In your original example if(not WildMatch (AMID_ID,'zzz*'),AMID_ID) as AMID you don't specify what the value should be if the condition is not met, which you do with the third parameter. The syntax is:

If(condition, return_if_true, return_if_false)

If you leave out third parameter, Null is always returned if false.

Re: Problem in Split one filed into two fileds with in Load Script

Fri, 31 Jul 2015 06:19:13 GMT

Hi,

Ok..I got your point. Actually I dnt want take ZZZ ids into AMID Field. So what is the way ?

I want AMID ids otherthan ZZZ..So in IF condition What i have to mention.?

Re: Problem in Split one filed into two fileds with in Load Script

sasiparupudi1 — Fri, 31 Jul 2015 06:20:59 GMT

LOAD YEAR,

AMID_ID,

Sale //,

//if(not WildMatch (AMID_ID,'zzz*'),AMID_ID,'na'&Right(AMID_ID,1)) as AMID

FROM

C:\sasi\qv\Demo_Split_filed.xls

(biff, embedded labels, table is [Sheet1$])

where WildMatch (AMID_ID,'zzz*')=0;

Re: Problem in Split one filed into two fileds with in Load Script

Fri, 31 Jul 2015 06:24:14 GMT

Hi,

I need Two fileds. I want ZZZ acounts include filed and Other than ZZZ acounts field..So is it possible.

AMID_ID ====>> All acounts ids

AMID=====>> Ohter than ZZZ ids

Re: Problem in Split one filed into two fileds with in Load Script

Fri, 31 Jul 2015 06:37:37 GMT

Hi to All,

Now i got.For this In IF condition i have to give third parameter. I dnt want that in front end ,so i have filter in front end this third paramter value..

My Expression: if(wildmatch(AMID_ID,'zzz*')<>1,AMID_ID,'TTTT') as AMID

So i dnt want TTTT in front end, so i have written if condition in front end.

Thanks to all help me a lot.

Re: Problem in Split one filed into two fileds with in Load Script

Ralf-Narfeldt — Fri, 31 Jul 2015 06:40:34 GMT

Great! Please remember to mark the question as Answered and set replies as Helpful/Correct!