topic Re: Dynamic column in table in QlikView

Dynamic column in table

Fri, 04 Apr 2014 10:58:02 GMT

I wonder how to make a dynamic table depending on the number of selected data. Example: counting the total sales in the month. I would like to be shown in the columns of months, depending on the date range.

example 1

Scope of the date of January 1, 2014 to March 31, 2014

Product	January 2014	February 2014	March 2014
Car	12562,32	456543,45	85266,32

example 2

Scope of the date of 1 November 2013 to 31 March 2014

Product	November 2013	December 2013	January 2014	February 2014	March 2014
Car	124564,32	456463,14	146232,23	456,36	1456,36

Re: Dynamic column in table

tresB — Fri, 04 Apr 2014 11:05:26 GMT

Try using pivot table.

Dimension1: Product

Dimension2: Months

Expression: Sum(Amount) // or something like that you would want

Then drag the second dimension column to the top.

Re: Dynamic column in table

MK_QSL — Fri, 04 Apr 2014 11:05:41 GMT

You can do the same using Conditional check of your selected month.

If you could provide some sample data would be helpful to give you answer...

Re: Dynamic column in table

sushil353 — Fri, 04 Apr 2014 11:10:19 GMT

Hi,

Create a normal pivot table with the two dimensions. Then in the table, drag the date dimension header (you'll see a marker when you start dragging) to the top of the table, and the marker will change to horizontal. Drop it there and you will have a cross table.

HTH

Sushil

Re: Dynamic column in table

its_anandrjs — Fri, 04 Apr 2014 11:10:38 GMT

You can do this any straight table also with

Dimension:- Product,Month,Year

Expression:- Sum(Sales)

Re: Dynamic column in table

its_anandrjs — Fri, 04 Apr 2014 11:17:49 GMT

Take a Straight table or a pivot table

Dimension:-

Product

Month Year

Expression :-sum(Sales)

Take a snap shot for that