Hi everyone!.
I have some doubts about the "pick" function in chart expression.
in my model i've created an inline table named Rank_Ingresos:
Rank_Ingresos:
load * inline[
Key_Ingresos, Rango_Ingresos
1, Menor a 2MM
2, 2 a 5MM
3, 5 a 10MM
4, Más de 10MM
];
the context is:
if Rango_Ingresos < 2.000.000 then 'Menor a 2MM'
if Rango_Ingresos between 2.000.000 and 5.000.000 then '2 a 5MM'
if Rango_Ingresos between 5.000.000 and 10.000.000 then '5 a 10MM'
if Rango_Ingresos > 10.000.000 then 'Más de 10MM'
"Rango_Ingresos" its like a "Rank_Sales"
"Total_ Ingresos" its like a "sum of sales"
Im trying to put the count of [Key_Cliente] (its like the ID) for measure the quantity of "rent modules" that they have per "rank_sales", and "sales" per rank,
i need to build a table like this:
1.-: I've tried to put manual values into the table and it works fine:
2.- when i've uncomment the first line and comment the "1", works fine to:
3.- but when i tried to put 2 expressions it doesnt work and the 2nd range dissapear:
4.- but when i do a basic sum and comment the line it works fine:
is there something that im missing?
i hope anybody can help me, and if someone need more information for this case, let me know.
Regards! and sorry for my bad english!
Stefan Grijalba.
Hi Stefan!
thanks for your fast reply!
asking your question, yes!, it works, i've created separated kpi for each rank:
but when i do this in the table it doesnt work:
as you can see, each rank has data, so, i dont understand what im missing.
Regards!.
Sorry, can't think of anything else right now. If you manually put 0 for the values, you will see all rows disappearing. You can deactivate that functionality here:
I know that this doesn't help you, it's just to illustrate that the result of the expression is indeed 0 (or NULL).
I just unmark that option and it shows the 0 values, but i dont understand why qlik view cant show the values for each rank, but if i put a basic sum it works.
im trapped in this case! =(
