topic Re: Multiple Values, same date in QlikView

Multiple Values, same date

evansabres — Mon, 11 Jun 2018 18:04:57 GMT

I have a field, [Game Date] for which there is the potential to have several data points associated to one particular [Game Date].

Example,

[Game Date] = 10/5/2017

totalsale = $171

qtysold = 2

however, there is also

[Game Date] = 10/5/2017

totalsale = $126

qtysold = 2

How do I show both instances of this [Game Date] as there are two separate transactions.

I am showing this in a table and used the expression: =FirstSortedValue(DISTINCT TOTALSALE, -[Game Date]), which only returns the first value. I am looking to return both (or however many there are) values

Re: Multiple Values, same date

Anonymous — Mon, 11 Jun 2018 18:29:25 GMT

Hello,

Try to use TOTALSALE and qtysold as dimension on your table, and Game Date as expression, like this:

=[Game Date]

Re: Multiple Values, same date

evansabres — Mon, 11 Jun 2018 18:33:18 GMT

This did not function correctly for me

Re: Multiple Values, same date

Anonymous — Mon, 11 Jun 2018 18:39:11 GMT

With this data ...

Data:

Load * Inline

[Game Date, TOTALSALE, qtysold

10/5/2017, 171, 2

10/5/2017, 126, 2

10/5/2017, 126, 3

];

... and a table configured like I said, it gives me this result:

Isn't it what you trying to achieve?

Re: Multiple Values, same date

evansabres — Mon, 11 Jun 2018 18:43:24 GMT

That is what I am attempting to achieve. However, when make my dimension of Game Date an expression and totalsale and qty the dimensions, the results are not as expected. There should be 39 results, and there are only a dozen or so.

Re: Multiple Values, same date

Anonymous — Mon, 11 Jun 2018 18:56:25 GMT

Ok!

Try to add another field to your table in script, in this case the row number:

Data:

Load *,

RowNo() As RowNumber

Inline

[Game Date, TOTALSALE, qtysold

10/5/2017, 171, 2

10/5/2017, 126, 2

10/5/2017, 126, 3

13/5/2017, 126, 3

];

And build your table like this:

Dimension: RowNumber

Expressions:

=[Game Date]

=TOTALSALE

=qtysold

On "presentation" tab, check "hide column" for the "RowNumber" Column.

Result:

Re: Multiple Values, same date

MarcoWedel — Mon, 11 Jun 2018 20:06:55 GMT

If you want to show those three fields as is, you might just use a table box instead.

Re: Multiple Values, same date

evansabres — Tue, 12 Jun 2018 12:28:58 GMT

Is it possible to do expressions in a table box? In the straight table that I was trying to create, I had expressions that were more than just the field name. Is this possible in a table box?

Re: Multiple Values, same date

MarcoWedel — Tue, 12 Jun 2018 20:02:37 GMT

No, table boxes don't have the option to create expressions.

Re: Multiple Values, same date

qliksus — Wed, 13 Jun 2018 10:17:01 GMT

Why don't you use a straight table with TOTALSALE as dimension and expression and hide the expression field

Re: Multiple Values, same date

evansabres — Wed, 13 Jun 2018 12:43:46 GMT

This works for me, thank you