Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Help with dynamic Cross table using Pivot/Straight table

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

Tags (2)
4 Replies
Highlighted
Not applicable

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

Hi

use the pivote table

drag expressions and drop into vertically

let me know is it working or not

other wise give sample qvw.

Highlighted
MVP & Luminary
MVP & Luminary

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

Hi,

Can you attach sample file?

Regards,

Jagan.

Highlighted
Not applicable

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

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

screenshot.JPG

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

Highlighted
Not applicable

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

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