topic Re: How to display cross tabular data in straight table ? in QlikView

How to display cross tabular data in straight table ?

ashok1203 — Fri, 03 Jul 2015 13:12:38 GMT

Hi, i want to display the data in cross tabular format in straight table.For reference see the attachment.

Anonymous — Fri, 03 Jul 2015 13:17:02 GMT

How about using a Pivot Table with the Always Fully Expanded option ticked to it looks like a Straight Table

Anonymous — Fri, 03 Jul 2015 13:19:11 GMT

you Need to define 12 expressions (for each month one and use set Analysis in each Expression)

sum({<Month={'Jan'}>}Sales

and so forth

I would do this Job only if customer really Needs it and Pivot table is not possible or allowed

Anonymous — Fri, 03 Jul 2015 13:40:55 GMT

Hi!

Why you dont want use a pivot like this?

Regards.

ashok1203 — Fri, 03 Jul 2015 13:54:15 GMT

You just specify how we do above scenario in pivot?

Anonymous — Fri, 03 Jul 2015 14:09:42 GMT

As I do in the file that you can find in my post you do this:

- create a pivot table ad insert Year and Month in dimension, sum(sales) in expression,

- drag and drop Month from column to row;

- in the presentation tab of the pivot table select Year (NOT Month) dimension and tyck Show Partial Total:

ashok1203 — Fri, 03 Jul 2015 14:50:57 GMT

Thanks for Reply. Is their any way in straight tables except set expressions.

Anonymous — Fri, 03 Jul 2015 15:08:37 GMT

I think that you should use set expression in the straight table.