Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jtrillori
Partner - Contributor
Partner - Contributor

Table simple .. count(min(week) where week is not a dimension

good morning,

to see if you can help me,  please

I have a set of items with a delivery date of order,  In the script I calculate the load weekname both dates.

item order date w_od_name delivery date w_dd_name
101/01/20142014/0101/01/20142014/01
303/01/20142014/0101/01/20142014/01
305/01/20142014/0101/01/20142014/01
507/01/20142014/0201/01/20142014/01
511/01/20142014/0201/01/20142014/01
104/01/20142014/0106/01/20142014/02
202/01/20142014/0106/01/20142014/02
406/01/20142014/0206/01/20142014/02
410/01/20142014/0208/01/20142014/02
318/01/20142014/0308/01/20142014/02
219/01/20142014/0329/01/20142014/05

the goal is to represent the number of different items that are delivered in the MIN w_od_name, being requested a w_dd_name as dimension. I get

w_od_name MinString(w_dd_name) count(if(w_dd_name=MinString(total w_dd_name),item))
2014/01 5
2014/012014/013
2014/022014/012
2014/032014/020

I get to set the number of items for the lowest week of the document but not the dimension

please,, help me

thanks and regards

0 Replies