topic Re: Table design in QlikView

Table design

Anonymous — Tue, 04 Nov 2014 17:04:22 GMT

Hello,

I have the following table two different ways, but the user is looking for something different. Here are the tables:

The user would like the 1st table to be augmented as follows:

Month 2014 Plan 2013

6 55.8 54.5 56.5

Variation -1.3pp .7pp

Can this be done? I have not found a way to drag the field as such, and could not find the correct syntax to create a calculated field.

Thanks in advance for the help!

Re: Table design

ecolomer — Tue, 04 Nov 2014 21:05:28 GMT

Yes this is possible, but you need to have 2 tables, one of them is the first without two columns for Var.

And the second table you need to put the values with formulas

Re: Table design

Anonymous — Tue, 04 Nov 2014 21:27:50 GMT

Enrique,

Thank you for the response, can you describe a little further or display. I am having trouble putting together your suggestion.

Re: Table design

JonnyPoole — Tue, 04 Nov 2014 21:46:28 GMT

As an alternative i think you could turn on a TOTALs rows and use if() logic in the expression with Dimensionality() to conditionally calculate the totals differently. Then its in 1 chart.

if ( Dimensionality()=0,

num( sum( {$<Year={2011}>} Sales) / sum(Sales),'#,##0.0%')

num(sum(Sales),'$#,##0.00;($#,##0.00)')

)

Re: Table design

Anonymous — Wed, 05 Nov 2014 00:35:41 GMT

Hi,

Using cross table you may achieve it.

Regards,

Chinna

Re: Table design

Anonymous — Wed, 05 Nov 2014 13:50:51 GMT

Jonathan,

Thank you that worked like a charm. Bailed me out again. I didn't think to use the dimensionality function, nor am I really familiar with that function and proper ways to use. Thanks again!