topic SCRIPT in QlikView

SCRIPT

upaliwije — Wed, 03 Jul 2019 09:24:08 GMT

Hi Friends,

I have attached my qv Document with following pivot Table

Current Output

Required Output

Kindly help to obtain above output with RTYPE filled with REN

Re: SCRIPT

Simon_Astakhov — Wed, 03 Jul 2019 10:08:30 GMT

Hi!

Best way is fill data with required values.

But shortest solution for you is make second Calculated dimention with (for example) =IF(IsNull(RTYPE),'REN',RTYPE). It fills null values in report by REN string.

If you need to split merged cell in qlik - just transform pivot table to straight.

Re: SCRIPT

upaliwije — Wed, 03 Jul 2019 10:40:10 GMT

Thanks

Is there a way where I can do it at script level ?

Re: SCRIPT

Simon_Astakhov — Wed, 03 Jul 2019 11:09:02 GMT

I think - yes. But sample application contain data connection and i cannot test it.

Try to use

if(FLG=2 and peek(POLICY_NO)=POLICY_NO and Peek(P_FROM)=P_FROM and Peek(R_SEQ)=R_SEQ and peek(FLG)=1,Peek(RTYPE),TYPE) AS RTYPE

in 42's script row.

Re: SCRIPT

Brett_Bleess — Tue, 06 Aug 2019 15:48:13 GMT

If Simon's posts helped you with things, please be sure to give him credit by clicking the Accept as Solution on the post(s) that helped. This also lets other posters know that things resolved your situation too. If you require further help, please update the post.

Regards,
Brett