Qlik Sense - Date

[psenthilbtech]

Hi Team,

I have a requirement

OPERATOR	PSC	FIELD	31/10	1	2	3
EMEPMI	2008 PSC	Guntong-D/E	3.2	3.2	3.2	3.2
EMEPMI	2008 PSC	Palas-A	0.6	0.6	0.6	0.6
EMEPMI	2008 PSC	Tabu-A	1.5	2.5	2.5	2.5
EMEPMI	2008 PSC	Guntong-A/B/C/F	5.5	9.8	9.8	9.8

The Dates here are mentioned as 1 , 2 , 3 till monthend. How to handle this situation ,  Need your input on this.

Regards,

senthil         

[MK_QSL]

You can use CrossTable !!

But what is meaning of 1,2,3??? Are they belongs to current month?

[psenthilbtech]

That is the date

1 for 1/11/2017 (DD/MM/YYYY)

2 for 2/11/2017

[MK_QSL]

Use CrossTable load.

The Crosstable Load