topic Not all values shown in QlikView

Not all values shown

nenadvukovic — Fri, 13 Mar 2015 15:41:50 GMT

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

Re: Not all values shown

beck_bakytbek — Fri, 13 Mar 2015 15:47:44 GMT

Hi Nenad,

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

Beck

Re: Not all values shown

nenadvukovic — Fri, 13 Mar 2015 15:50:13 GMT

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

];

Re: Not all values shown

nenadvukovic — Sat, 14 Mar 2015 17:00:38 GMT

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