Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Re: How to compare Same Quarters of Differennt years?

Would you be able to share your script you are using? Difficult to comment without seeing

Highlighted
Creator
Creator

Re: How to compare Same Quarters of Differennt years?

LOAD *,

  Dual(Year & '-' & Quarter, (Year & Num(PurgeChar(Quarter, 'Q'), '00')) * 1) as YearQuarter;

LOAD Year,

     Quarter,

     Sales,

     [Other Income],

     [Total Revenue]

FROM

(biff, embedded labels, table is Main$);

LinkTable:

LOAD YearQuarter as ReportingYearQuarter,

  YearQuarter,

  'CYQ' as Flag

Resident Main;

Concatenate (LinkTable)

LOAD YearQuarter as ReportingYearQuarter,

  YearQuarter - 100 as YearQuarter,

  'PYQ' as Flag

Resident Main;

Highlighted
Creator
Creator

Re: How to compare Same Quarters of Differennt years?

Where to use these 2 expressions

whether in script area or in chart as expression ???

Highlighted

Re: How to compare Same Quarters of Differennt years?

Would you also be able to share the logfile to check out the error?

Highlighted
Creator
Creator

Re: How to compare Same Quarters of Differennt years?

Lets say I have an excel file which contains worksheet having above data named "Main".

Now what will be my script???

Regards,

Khayam

Highlighted

Re: How to compare Same Quarters of Differennt years?

Your tab name on the Excel says Main? What does this has to with what we are discussing here my friend. Would you not be able to share the logfile? I can quickly glance over your logfile and see what might need to change.

Highlighted
Creator III
Creator III

Re: How to compare Same Quarters of Differennt years?

If I select Year it's give only one Quarter Data instead it should give previous Year Data as well.

For eg. When I select 2015 it's should show 2014 Max Quarter also