topic Re: How to insert a blank row into a field after each value in App Development

How to insert a blank row into a field after each value

dandaanilreddy — Wed, 27 Sep 2023 13:51:23 GMT

Hello All,

I have a user requirement to show blank row after each dimension field value. Please can someone let me know how can i insert blank record while loading the table into qlik sense? I have attached the sample data and the expected output.

Thank You!!

Re: How to insert a blank row into a field after each value

sbaro_bd — Wed, 27 Sep 2023 15:10:41 GMT

Hi @dandaanilreddy ,

With the native objects, it's not possible. Perharps with a extension if this one exists. Explain that to your end users (be diplomatic) . The current view is also good.

Regards.

Re: How to insert a blank row into a field after each value

dandaanilreddy — Wed, 27 Sep 2023 20:09:12 GMT

@sbaro_bd

Thanks for your response. Is there any possibility to achieve the below output (attached) in straight table ?

Expected Output In Straight table
Samsung	TV
Samsung	Mobile
Samsung	Home Theater

Apple	Ipad
Apple	Desktop
Apple	Mobile
Apple	Airpods

Re: How to insert a blank row into a field after each value

pallavi_96 — Thu, 28 Sep 2023 07:36:06 GMT

Hi Dandaanilreddy,

Your problem has a workaround, which I have.This should be able to assist you, I hope.

Table:
LOAD * Inline [
Brand ,Product
Samsung ,TV
Samsung ,Mobile
Samsung ,Home Theater
Apple ,Ipad
Apple ,Desktop
Apple ,Mobile
Apple ,Airpods
];
Left Join(Table)
LOAD Brand,
If(Brand = Previous(Brand), Peek('RowNo'), RangeSum(Peek('RowNo'), 1)) as RowNo
Resident Table
Order By Brand;

NoConcatenate
Blank:
Load *,
if(len(Brand)<=0,'',Product) as NewProduct;
Load
Product,
Brand as oldBranch,
RowNo,
If(RowNo <> Previous(RowNo), '', Brand) as Brand
Resident Table
Order By RowNo;

drop table Table;
exit script;

Re: How to insert a blank row into a field after each value

dandaanilreddy — Thu, 28 Sep 2023 12:55:28 GMT

@pallavi_96 Thank You for your help. This will work but only issue here is using row no as dimension which is ok as without adding row no blank line wont appear in the table. Just checking with you if there is any way we can hide the row no in the dimension but still get the expected output?

Thank You!!!

Re: How to insert a blank row into a field after each value

pallavi_96 — Fri, 29 Sep 2023 05:22:50 GMT

Hello, @dandaanilreddy

I'll try to think of another approach and get back to you.

Regards,

Pallavi