topic Re: Help with dynamic Cross table using Pivot/Straight table in QlikView

Help with dynamic Cross table using Pivot/Straight table

Fri, 25 Oct 2013 06:00:58 GMT

hello everyone..

I am facing a problem..

What I want is to create a dynamic cross table using straight table or Pivot table in Qlikview..

It goes lyk dis:

----Current Period---- -----------Previous Period------------

Sep-13 Sep-12 Mar13-Sep-13 Mar-12-Sep13

Cost Price 100 150 3000 3250

Selling Price 120 200 4200 5000

Profit 20 50 1200 1750

Here, the values :

1. sep-13 is the max(MonthYear) i.e the current month

2. Sep-12 is the max(MonthYear)-12 i.e same month last year

3. Mar-13 - Sep-13 is the last six MonthYear period

4. Mar-12 - Sep-12 is the last six months period for the last year.

what i wanna say is, the dimensions are calculated. i.e. all these four values will be coming from different expression but I want them to be displayed in a single header row.

Please help..

Thanks

Re: Help with dynamic Cross table using Pivot/Straight table

Fri, 25 Oct 2013 06:24:35 GMT

use the pivote table

drag expressions and drop into vertically

let me know is it working or not

other wise give sample qvw.

Re: Help with dynamic Cross table using Pivot/Straight table

jagan — Fri, 25 Oct 2013 06:33:34 GMT

Hi,

Can you attach sample file?

Regards,

Jagan.

Re: Help with dynamic Cross table using Pivot/Straight table

Fri, 25 Oct 2013 06:39:07 GMT

hi..
I am attaching a screenshot of the required output...

Plz try and guide me here only..As I am using the personal edition of Qlikview, I wont be able to access the .qvw file if you send one....

Thanks

Re: Help with dynamic Cross table using Pivot/Straight table

Fri, 25 Oct 2013 06:46:00 GMT

I would like to highlight that I have the following fields:

1. Date

2. Month

3.Year

4. MonthYear

5. Charges

6. Payments

7. Adjustments

8. Refunds

The metric 'Beginning Balance' is the running sum of all the transactions from the beginning till the start of the current month.

Also Net Activity is the sum of the transaction for this month

Adding Net Activity to the Beginning Balance gives the Ending Balance.

What I want is to have the current month i.e Sep-13, same month last year i.i Sep-12 etc as the dimension which have been dragged above. And the sum(Charges) as Charges etc.. as Expressions