Filtering pivot with date variables

[paolojolly]

Hi I'm new in Qlikview and I need help to create a pivot table from the follow excel table

C_CLIENTE	C_LINEA_FAT	C_LISTINO_RIGA	DATA_FATTURA	DATA_RIF_DOC	Group	mese	P_SC_CAN1_CNT	P_SC_CAN2_CNT	P_SC_CAN3_CNT	P_SC_COMP_CNT	P_SC_DERIVA_COMPLETA_CNT
C0000009	005	000085	15/01/2009	07/01/2009	588	0,00	0,19	0	0	0,1	0,450001666
C0000009	005	000085	15/01/2009	12/01/2009	588	0,00	0,19	0	0	0,1	0,450001666
C0000009	005	000085	15/01/2009	13/01/2009	588	0,00	0,19	0	0	0,1	0,450001666
C0000009	005	000085	15/01/2009	14/01/2009	588	0,00	0,19	0	0	0,1	0,450001666
C0000009	005	000085	31/01/2009	15/01/2009	588	0,00	0,19	0	0	0,1	0,450001666
C0000009	005	000085	31/01/2009	16/01/2009	589	0,00	0,19	0	0	0,15	0,480557129
C0000009	003	000085	31/01/2009	20/01/2009	586	0,00	0,19	0	0	0	0,38889074
C0000009	003	000085	31/01/2009	28/01/2009	586	0,00	0,19	0	0	0	0,38889074
C0000009	003	000085	15/02/2009	03/02/2009	586	0,00	0,19	0	0	0	0,38889074
C0000009	003	000085	15/02/2009	11/02/2009	586	0,00	0,19	0	0	0	0,38889074
C0000009	003	000085	28/02/2009	17/02/2009	586	0,00	0,19	0	0	0	0,38889074
C0000009	003	000085	15/03/2009	03/03/2009	586	0,00	0,19	0	0	0	0,38889074
C0000009	003	000089	15/03/2009	03/03/2009	587	0,00	0,19	0	0	0	0,38889074
C0000009	003	000089	15/03/2009	11/03/2009	587	0,00	0,19	0	0	0	0,38889074
C0000009	003	000089	31/03/2009	17/03/2009	587	0,00	0,19	0	0	0	0,38889074

in qlikview document I added two slider object for filterig by DATA_RIF_DOC

In the pivot i need to have C_CLIENTE as dimension and as expression for the max Group field for the selection period the values of fields

P_SC_CAN1_CNT

P_SC_CAN2_CNT

P_SC_DERIVA_COMPLETA_CNT

MIN(DATA_RIF_DOC)

MAX(DATA_RIF_DOC)

I attach a sample document with data

I have tried using FirstSortedValue.

is the correct way?

Can someone help me?

thanks

[#2]

Ho Paolo,

didn't catch exactly what you want, so check my guesses.

Hope this points into right direction.

Roland

[ashwanin]

Hi ,

Firstly you need to upload the excel file ( which contains data only) in the QV and the create Pivot table there.

Happy Qliking

[paolojolly]

Maybe I have not explained properly my problem. For example, i set date variable in the slider from 10/06/2009 to 13/01/2009

C_CLIENTE	C_LINEA_FAT	C_LISTINO_RIGA	mese	DATA_FATTURA	DATA_RIF_DOC	Group	P_SC_CAN1_CNT	P_SC_CAN2_CNT	P_SC_CAN3_CNT	P_SC_COMP_CNT	P_SC_DERIVA_COMPLETA_CNT
C0000009	003	000089	0,00	15/06/2009	03/06/2009	587	0,19	0	0	0	0,38889074
C0000009	003	000089	0,00	15/06/2009	10/06/2009	587	0,19	0	0	0	0,38889074
C0000009	003	000089	0,00	30/06/2009	16/06/2009	587	0,19	0	0	0	0,38889074
C0000009	003	000089	0,00	30/06/2009	24/06/2009	587	0,19	0	0	0	0,38889074
C0000009	003	000089	1,00	15/07/2009	30/06/2009	587	0,19	0	0	0	0,38889074
C0000009	003	000089	0,00	15/07/2009	08/07/2009	587	0,19	0	0	0	0,38889074
C0000009	003	000089	0,00	15/07/2009	14/07/2009	587	0,19	0	0	0	0,38889074
C0000009	005	000085	0,00	15/01/2009	07/01/2009	588	0,19	0	0	0,1	0,450001666
C0000009	005	000085	0,00	15/01/2009	12/01/2009	588	0,19	0	0	0,1	0,450001666
C0000009	005	000085	0,00	15/01/2009	13/01/2009	588	0,19	0	0	0,1	0,450001666
C0000009	005	000085	0,00	15/01/2009	14/01/2009	588	0,19	0	0	0,1	0,450001666
C0000009	005	000085	0,00	31/01/2009	15/01/2009	588	0,19	0	0	0,1	0,450001666
C0000009	005	000085	0,00	31/01/2009	16/01/2009	589	0,19	0	0	0,15	0,480557129

and in the pivot i need to get only 1 record like

C_CLIENTE	Group	P_SC_CAN1_CNT	P_SC_CAN2_CNT	P_SC_CAN3_CNT	P_SC_COMP_CNT	P_SC_DERIVA_COMPLETA_CNT	min DATA_RIF_DOC	max DATA_RIF_DOC
C0000009	588	0,19	0	0	0,1	0,450001666	10/06/2009	13/01/2009

in which for the max  Group values in the selection period(588) are shows the corresponding values ​​of

P_SC_CAN1_CNT
P_SC_CAN2_CNT
P_SC_CAN3_CNT
P_SC_COMP_CNT

P_SC_DERIVA_COMPLETA_CNT

and the min e max values of field DATA_RIF_DOC

thanks for your help

[#5]

Pls check pivottable RK in attached example.

BTW: Is

Min(DATA_RIF_DOC)  = 10/06/2009 ?

max(DATA_RIF_DOC)  = 13/01/2009 ?

correct ?

Do you mean 13/01/2010