Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
techvarun
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
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
CELAMBARASAN

Can you attach sample file?

techvarun
Specialist II
Specialist II

Hi Celamb,

     Thanks for ur quick reply.

      Updated the question with input excel.

Regards

jpapador
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,

Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

techvarun
Specialist II
Specialist II

Am using QlikView P E

Gysbert_Wassenaar

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