Discussion Board for collaboration related to Creating Analytics for QlikView.
Hi I'm new in Qlikview and I need help to create a pivot table from the follow excel table
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
I attach a sample document with data
I have tried using FirstSortedValue.
is the correct way?
Can someone help me?
didn't catch exactly what you want, so check my guesses.
Hope this points into right direction.
Firstly you need to upload the excel file ( which contains data only) in the QV and the create Pivot table there.
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
and in the pivot i need to get only 1 record like
in which for the max Group values in the selection period(588) are shows the corresponding values of
and the min e max values of field DATA_RIF_DOC
thanks for your help
Pls check pivottable RK in attached example.
Min(DATA_RIF_DOC) = 10/06/2009 ?
max(DATA_RIF_DOC) = 13/01/2009 ?
Do you mean 13/01/2010