Set analisys, Filter

Wed, 23 Mar 2016 19:33:08 GMT

Hi, i have a trouble with set analisys expression is the column stock in the table, i have a filter done like can see it in the list with number 1, where i choose an item, but the table show me 4 item how can see in the number 2, is all the family of the choose, i can't repair this, and i want that the choose show correctly in the table.

the expression that i have is the next. where the items select and no filter is Articulo_RubroCod

num(if($(vRdLUnidades) = 1, sum({1<Deposito_Nombre=$::Deposito_Nombre, Deposito_LocalTipo=$::Deposito_LocalTipo, Deposito_Tipo-={'CENTRAL'}, Deposito_CategoriaImagen=$::Deposito_CategoriaImagen, Articulo_RubroCod=$::Articulo_RubroCod, Articulo_GrupoCod=$::Articulo_GrupoCod, Línea=$::Línea, Marca=$::Marca, Articulo_Temporada=$::Articulo_Temporada, Articulo_Coleccion=$::Articulo_Coleccion, Articulo_Modelo=$::Articulo_Modelo, Articulo_RubroCod-={$(vGeneralExcludeRubros)}>} Stock_Actual),

sum({1<Deposito_Nombre=$::Deposito_Nombre, Deposito_LocalTipo=$::Deposito_LocalTipo, Deposito_Tipo-={'CENTRAL'}, Deposito_CategoriaImagen=$::Deposito_CategoriaImagen, Articulo_RubroCod=$::Articulo_RubroCod, Articulo_GrupoCod=$::Articulo_GrupoCod, Línea=$::Línea, Marca=$::Marca, Articulo_Temporada=$::Articulo_Temporada, Articulo_Coleccion=$::Articulo_Coleccion, Articulo_Modelo=$::Articulo_Modelo, Articulo_RubroCod-={$(vGeneralExcludeRubros)}>} Stock_Actual * Articulo_Precio)), $(vSyVFormat))

thanks in advance

Re: Set analisys, Filter

jepeerik — Wed, 23 Mar 2016 22:21:12 GMT

The table is showing zero's in the rest of the column (Ventas), so your Set Analysis is probaly working correctly. But because there are rows which will still have a result of an expression (column Stock), the dimension rows with results will still appear.

Re: Set analisys, Filter

Mon, 28 Mar 2016 14:06:08 GMT

doesn't exist any set analisys that respect the filter do ?

topic Set analisys, Filter in QlikView

Set analisys, Filter

Re: Set analisys, Filter

Re: Set analisys, Filter