topic Need help ... in QlikView

Need help ...

vinod2086 — Mon, 04 May 2015 09:04:41 GMT

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.

Re: Need help ...

jyothish8807 — Mon, 04 May 2015 09:43:58 GMT

Hi Vinod,

Is this what you want?

Regards

Re: Need help ...

sujeetsingh — Mon, 04 May 2015 09:52:21 GMT

Seems you need to come in more words.

Re: Need help ...

avinashelite — Mon, 04 May 2015 10:08:28 GMT

hi vinod,

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

Re: Need help ...

vinod2086 — Mon, 04 May 2015 10:24:09 GMT

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

Re: Need help ...

vinod2086 — Mon, 04 May 2015 10:25:17 GMT

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

Re: Need help ...

vinod2086 — Mon, 04 May 2015 10:26:29 GMT

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

Re: Need help ...

jyothish8807 — Mon, 04 May 2015 12:22:11 GMT

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

Re: Need help ...

vinod2086 — Wed, 06 May 2015 09:41:23 GMT

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

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