Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

YTD Analysis

Hi,

        I have data for two years and i want to display the result in a particular format. I have all the formulas and values are ready with me and needs the help from you to display the data in the format as per requirement.

attached the file which I have and the format which I need to show the output.

Attached is the Screenshots of the Input and output values

Thanks in Advance

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Highlighted

Can you attach sample file?

Highlighted
Specialist II
Specialist II

Hi Celamb,

     Thanks for ur quick reply.

      Updated the question with input excel.

Regards

Highlighted
Partner
Partner

You can create a Year to Date field in your calendar that will flag dates in previous years up to today.  It would look something like this in your script:

  If(InYearToDate(Date, $(vTodaysDate), 0)

                or InYearToDate(Date, $(vTodaysDate), -1)

                or InYearToDate(Date, $(vTodaysDate), -2)

                or InYearToDate(Date, $(vTodaysDate), -3)

                or InYearToDate(Date, $(vTodaysDate), -4)

                , 'YTD') as YTD,

Highlighted
MVP & Luminary
MVP & Luminary

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Specialist II
Specialist II

Am using QlikView P E

Highlighted
MVP & Luminary
MVP & Luminary

This is the script:

CrossTable(Year,Amount,2)

LOAD subfield(Year,'_',1) as KPI, SubField(Year,'_',-1) as Period,

     [2013],

     [2012]

FROM Input_YTD.xls (biff, embedded labels, table is [Sheet1$]);

And the pivot table looks like this:

comm90286.png

You can see the only expression of the pivot table in the caption. The dimensions Period and Year have been dragged to above the expression so they show horizontally.


talk is cheap, supply exceeds demand