Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

jtrillori
New 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

Community Browser