Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MarcoMartinez
Partner - Contributor II
Partner - Contributor II

Problem Analysis Set min function in pivot table

Hello!

The table shows a number of families with their items, you can see we have three columns, the first shows the minimum time for each item, the second is a summation of the field quantity and the third makes us a summation of the minimum amount on the date per item (sum ({$ <Date = {$(='"<='& min (Date )&'"')}> Number})) the problem we see is that this makes the minimum set of items in rather than for each item, ie for each line.

In what way can we do this for us to take the minimum time per item?


0 Replies