Need Help

paulwalker — Wed, 28 Jan 2015 15:54:49 GMT

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,

Re: Need Help

paulwalker — Wed, 28 Jan 2015 16:20:02 GMT

Anyone faced this type issue????

Re: Need Help

sujeetsingh — Wed, 28 Jan 2015 18:10:26 GMT

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

];

Concatenate(MainData)

LOAD

Resident Data where Number<=3;

Concatenate (MainData)

LOAD * INLINE [

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

];

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;

Re: Need Help

sunny_talwar — Wed, 28 Jan 2015 18:24:28 GMT

Is this what you want to achieve? PFA

Best,

Re: Need Help

sunny_talwar — Wed, 28 Jan 2015 18:37:59 GMT

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

Best,

topic Need Help in QlikView

Need Help

Re: Need Help

Re: Need Help

Re: Need Help

Re: Need Help