Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rammuthiah
Contributor II

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
Esteemed Contributor II

Re: Cross Table - Date Logic

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

The Generic Load

beck110979
Valued Contributor III

Re: Cross Table - Date Logic

Hi Ram,

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

i hope thate helps

Beck

MVP
MVP

Re: Cross Table - Date Logic

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.