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: 
paolojolly
Creator
Creator

Min and Max date in pivot

Hi All,

I have a problem with the following document:

In a table for each item I have price and date of document fields

In a pivot chart I need to have for each item the last price in the filtered period ad the first and last document date of this price.


I need to calculate the information directly on pivot chart without change script


For example for item 005 last price is 0.94, last doc date for this price is 04/11/2014 and fist date for this price should be 15/10/2013.

I attach a sample document

Can someone help me?

Many thanks

5 Replies
MK_QSL
MVP
MVP

Add more more expression and remove 2nd dimension

FirstSortedValue(DISTINCT W_PRZ_LIS,-DATA_INI_RIGALIS)

paolojolly
Creator
Creator
Author

Thanks. I tried to follow your suggestion but I did not get the result I need

MK_QSL
MVP
MVP

Upload the result you are looking for...

paolojolly
Creator
Creator
Author

I need something like that

ITEMPRICE in LAST DOCMIN DATE OF DOC  WITH THIS PRICEMAX DATE OF DOC  WITH THIS PRICE
0050,9415/10/201304/11/2014
0251,3815/10/201304/11/2014


Thanks

giakoum
Partner - Master II
Partner - Master II

that should give you the price :

firstsortedvalue (total <ITEM> W_PRZ_LIS, -DATA_RIF_DOC, 1)