Cross Table - Date Logic

[rammuthiah]

I have data with several dates and want to show like below.

Sample input data and output given below

Input :

PN	CN	Date	Value
1	A	4/9/2017	1
1	A	5/9/2017	1.5
1	B	5/9/2017	1.5
1	B	6/9/2017	1.6
1	B	7/9/2017	1.55
2	A	4/9/2017	1
2	B	3/9/2017	1.25
2	B	5/9/2017	1.25
2	C	4/9/2017	1
2	C	5/9/2017	1.5

Should be like :

[vinieme12]

just Pivot the Date field in a Pivot Table or Look at Generic Load

The Generic Load

[beck_bakytbek]

Hi Ram,

look at this: https://community.qlik.com/thread/262550

i hope thate helps

Beck

[jagan]

Hi,

Try like this

Data:

LOAD

*,

'Date' & AutoNumber(YourDateFieldName) AS DateNumber

FROM DataSource;

Now use Pivot table, drag DateNumber and your date field to top then you can get the similar layout.

Regards,

Jagan.