SCRIPT

[upaliwije]

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 

[Simon_Astakhov]

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.

[upaliwije]

Thanks

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

[Simon_Astakhov · Accepted solution]

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.

[Brett_Bleess]

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