Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanks
Is there a way where I can do it at script level ?
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.
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