Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rammuthiah
Creator III
Creator III

Cross Table - Date Logic

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. 1.5

1

B

5/9/2017

  1. 1.5

1

B

6/9/2017

  1. 1.6

1

B

7/9/2017

  1. 1.55

2

A

4/9/2017

1

2

B

3/9/2017

  1. 1.25

2

B

5/9/2017

  1. 1.25

2

C

4/9/2017

1

2

C

5/9/2017

  1. 1.5

Should be like :

Output Cross Table.JPG

3 Replies
vinieme12
Champion III
Champion III

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

The Generic Load

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
beck_bakytbek
Master
Master

Hi Ram,

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

i hope thate helps

Beck

jagan
Luminary Alumni
Luminary Alumni

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.