topic Re: All true values comes into new columns in QlikView

All true values comes into new columns

Srinivas — Wed, 24 Sep 2014 03:28:05 GMT

Hi All,

I Have different columns in that some values are matched and some are not matched so whatever matched those are TRUE if not matched those are FALSE(Here have one flag once see the attached then u can understand).

Here my query is all matched values comes into one NEW COLUMNS like i attached screen shot way and also data.

(My Out put is as same Screenshot way)

Could you please help on this.

Regards

munna

Re: All true values comes into new columns

Srinivas — Wed, 24 Sep 2014 03:39:54 GMT

Hi All,

my script is like below way but it's not working.

LOAD ID,

CD,

SCD,

NUMBER,

ITEM,

if(Flag='TRUE',value) as PROD,

Flag

FROM

(biff, embedded labels, table is Sheet1$);

Regards

Munna

Re: All true values comes into new columns

senpradip007 — Wed, 24 Sep 2014 03:58:20 GMT

As per your png file you can use like

Load

ID,

CD,

SCD,

NUMBER,

ITEM,

Flag,

If(Flag='TRUE', ITEM) As Prod

From <>;

Re: All true values comes into new columns

Srinivas — Wed, 24 Sep 2014 04:52:39 GMT

Thanks for your reply Pradip,But not coming correct values.

Re: All true values comes into new columns

senpradip007 — Wed, 24 Sep 2014 05:01:02 GMT

Could you please upload sample qvw?

Re: Re: All true values comes into new columns

senpradip007 — Wed, 24 Sep 2014 05:27:32 GMT

PFA

Re: All true values comes into new columns

jyothish8807 — Wed, 24 Sep 2014 05:29:17 GMT

Hi Munna,

Try this.

Load

ID,

CD,

SCD,

NUMBER,

ITEM,

Flag,

If(text(Flag)='TRUE', SCD,"") As New_Col

From <>;

Regards