topic Re: Table help in QlikView

Table help

joshrussin — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to get the order departure from average percentage, but trying to get the percentage for each day on the table. It works in a text box, just not the table.

Essentially,

This is the equation I am using.

sum(((sum([Orders Submitted]))

((Count({$<Year_BV = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,(vHolidaysBV))))"}>}

distinct [Date Bioventus]) -1)

(sum({$<Year_BV = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,(vHolidaysBV))))"}>} [Orders Submitted]))))-1)

Any help?

Re: Table help

m_s — Mon, 28 Aug 2017 15:44:38 GMT

Hello Joshua,

that's because the expression

Count({$<Year_BV = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,(vHolidaysBV))))"}>}

distinct [Date Bioventus]) -1

always returns 0 in your table (with Dimension Date Bioventus) which means that you try to divide by 0.

Mathias

Re: Table help

joshrussin — Mon, 28 Aug 2017 15:48:58 GMT

But in the text box, that equation returns '160' which is correct.

Re: Table help

joshrussin — Mon, 28 Aug 2017 15:58:06 GMT

How else could i count the days consumed within the table?

Re: Table help

m_s — Tue, 29 Aug 2017 08:16:28 GMT

It is because your table dimension is Date Bioventus and you are counting Date Bioventus (which will then always be 1).

Maybe try to use the month / year as dimension, then your day count will be greater than 1.

Re: Table help

joshrussin — Tue, 29 Aug 2017 21:44:49 GMT

I added TOTAL and it counted it with no issues. Thanks for your help.