topic Re: How to create a Dynamic Straight Table. in QlikView

How to create a Dynamic Straight Table.

Mon, 19 May 2014 18:20:56 GMT

Hi,

I have loaded a table with Customer_ID, Sales, Date, Month, Year and Quarter as columns.

I have to show a straight table with 3 columns (any quarter, based on user selection), like sales of 3 months.(Jan, Feb, Mar)

As I said above, 'Quarter' has 4 values, like Q1, Q2, Q3 and Q4.

Condition#1

How to create a straight table with dynamic columns, like if the user selects on Q1 -> sale for the month of Jan, Feb, Mar has to show.

If the user selects on Q2 -> sale for the month of Apr, May, June has to show.

If the user selects on Q3 -> sale for the month of July, Aug, Sep has to show.

If the user selects on Q4 -> sale for the month of Oct, Nov, Dec has to show.

Condition#2

User can one or more quarters at a time, like Q1 & Q2, the total 6 months sales has to show.

If user selects all the quarters then 12 columns with 12 months sales has to show.

I'm using qlikview personal edition, so can't open any qvw files, please tell me the procedure how it can be done.

Thanks in Advance,

Pavan.

swuehl — Mon, 19 May 2014 18:41:32 GMT

Use your month field as dimension and an expression to aggregate your Sales

=sum(Sales)

You can enable option 'horizontal' in presentation tab to create columns for your dimension instead of rows.

Create a list Box for field quarter and select one quarter.

whiteline — Mon, 19 May 2014 18:44:59 GMT

Hi.

Why straight table ? I think Pivot table with moths placed in columns is suitable.

Just add Month as dimension and drag it with the mouse to the right until the blue horizontal arrow appears.