Not all values shown

[nenadvukovic]

Hi, I've been unable to find a way to get all values I would expect to get. I've also attached the demo app.

Issues:

1. Out of curiosity: If the "Show All Values" dimensions setting is selected I see one blank line at the top of tables A, B and C (in qvw). Why is that?

2. I would expect to see two lines marked in yellow in the All Data table as shown in table A1

3. Why the Total for Cust1 in table A is not shown as 1?

3. If I collapse the SKU dimension I lose the valid record Cust1 and SKU_1 (table B)

4. If I collapse the Customer dimension I lose the valid Cust1 (table C)

5. If I check the "Suppress Zero-Values" Expression setting for each table I get tables A1, B1 and C1 with incorrect data

I use this expression for the Flag or #SKUs which satisfy the condition I need to show:

if(sum({$<Date = {"<$(=date(today() - $(vTopN)))"}>} Qty) = 0 and sum({$<Date = {">=$(=date(today() - $(vTopN)))"}>} Qty) > 0, 1, 0)

What am I doing wrong or is there a better way to handle this. Note that in real app there are much more tables, dimensions and measures available.

Thanks

[beck_bakytbek]

Hi Nenad,

Do you have any zero values in your excel-sheets?

Beck

[nenadvukovic]

No. If you check the available qvw file or even the All Data table you will see this:

Test:

load * inline [

Salesman, Customer, SKU, Date, Qty

S1, Cust1, SKU_1, 15.1.2015, 1

S1, Cust1, SKU_2, 12.12.2014, 2

S1, Cust2, SKU_2, 15.12.2014, 3

S1, Cust2, SKU_3, 12.12.2014, 4

S1, Cust3, SKU_4, 20.1.2015, 5

];

[nenadvukovic · Accepted solution]

Another issue I was able to fix myself

sum(aggr(if(sum({$<Date = {"<$(=date(today() - $(vTopN)))"}>} Qty) = 0 and sum({$<Date = {">=$(=date(today() - $(vTopN)))"}>} Qty) > 0, 1, 0), Salesman, Customer, SKU))

Cheers