Pick Function

[SGrijalba]

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.

[steeefan]

If the row disappears, it suggests that the value of the expression is 0. Those are usually not shown. Is the expression working on its own in a different object?

[SGrijalba]

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!.

[steeefan]

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).

[SGrijalba]

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! =(

[SGrijalba]

Any idea how to resolve this?

thanks!

[steeefan]

Would be good if you could supply the data or the QVW/QVF file. Otherwise I cannot reproduce your current situation.