Need help ...

[vinod2086]

Hi Friends,

i have a requirement i have loaded Service_id id step_name status, and i have created 3 custom columns based on step_name , each step_name having different CLOSE_DATETIME, user asking all values should be in single column like step_name complete and STATUS should be closed.

for more information please open QV file.

and am expecting o/p like this

SERVICE_ID	ID	STEP_NAME	CLOSE_DATETIME	STATUS	Approved Date	Diapatch Date	Generated Date
09330354	101540	COMPLETE		Closed	09-12-2013 17:00:28	17-12-2013 18:55:51	09-12-2013 14:08:19

pls help me is it possible in Qlikview ?

Thanks in Advance.

[jyothish8807]

Hi Vinod,

Is this what you want?

Regards

KC

[sujeetsingh]

Seems you need to come in more words.

[avinashelite]

hi vinod,

Please find the attachment for the solution , I have use generic load for the conversion of the column.

[vinod2086]

Hi Avinash ,

Thanks for yr reply

but i have created 3 extra dimessions based on step name

my requirment is STATUS closed column only values should be display all generate dispath and approve date

like this

SERVICE_ID	ID	STEP_NAME	CLOSE_DATETIME	STATUS	Approved Date	Diapatch Date	Generated Date
09330354	101540	COMPLETE		Closed	09-12-2013 17:00:28	17-12-2013 18:55:51	09-12-2013 14:08:19

[vinod2086]

Hi jyothish i have already created extra columns need all values in single column

[vinod2086]

for reference pls find the attached xl file i have mentioned expected output.

[jyothish8807]

Hi Vinod,

I have used if condition at dimension level. Is it what you require?

It will ignore all the entries where Service ID is empty and put all entries in single row.

Its the previous attachment only.

Regards

KC

[vinod2086 · Accepted solution]

i used =Aggr(Concat(DISTINCT([Diapatch Date]),;),ID)

after click on check box supress when value is null then u will reah expected output