Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator III
Creator III

Need Help

Hi Community,

I have Excel data source..

i have 3 fields (NAME, LOCATION, PICKING AREA)

Here, every 7 records i want to show filed names..(NAME, LOCATION, PICKING AREA)

Please see excel format... i want to show like that format..

PFA,

4 Replies
paulwalker
Creator III
Creator III
Author

Anyone faced this type issue????

sujeetsingh
Master III
Master III

You need to follow some thing like this

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Tab:

LOAD * INLINE [

    Name, Location, Pickup

    1, A, AA

    2, D, DD

    3, F, WW

    4, A, EE

    5, A, EE

    6, D, RR

    7, F, RR

    8, T, TR

    9, W, QA

];

Data: NoConcatenate

LOAD

RecNo() as Number

,*

Resident Tab;

DROP table Tab;

MainData:NoConcatenate

LOAD * INLINE [

    Name, Location, Pickup,2

    Name, Location, Pickup,2

    ];

Concatenate(MainData)

LOAD

*

Resident Data where Number<=3;

Concatenate (MainData)

LOAD * INLINE [

    Name, Location, Pickup,3

    Name, Location, Pickup,3

    ];

   

Concatenate (MainData)

LOAD *

,RecNo() as Phase1

Resident Data where Number>3 and Number<=6;

Concatenate (MainData)

LOAD * INLINE [

    Name, Location, Pickup,4

    Name, Location, Pickup,4

    ];

Concatenate (MainData)

LOAD *

,RecNo() as Phase3

Resident Data where Number>6 and Number<=9;

Drop Table Data;

AllData:

Load

Name, Location, Pickup,Number

Resident MainData ;

DROP Table MainData;

sunny_talwar

Is this what you want to achieve? PFA

Best,

S

sunny_talwar

Last one had a slight error. Updated version of the application.

Best,

S