topic Re: Current Year Week vs. Previous Year Week in QlikView

Current Year Week vs. Previous Year Week

Thu, 16 Jun 2016 13:49:07 GMT

Hi all,

I am looking for some Help on how to get below chart

where Sale 2015 is showing same week sale on last year and Sale 2016 is showing same week sale on last year current year

by Weekends Date wise.

I have uploaded sample data with expected results in attached excl sheet.

Thanks in advance...!!

Re: Current Year Week vs. Previous Year Week

sunny_talwar — Thu, 16 Jun 2016 14:00:03 GMT

I just see the ouput in the file, can you provide the raw data to create this output?

Re: Current Year Week vs. Previous Year Week

Thu, 16 Jun 2016 14:09:48 GMT

It’s already on attached excel (Sheet Name Data) .

Re: Current Year Week vs. Previous Year Week

Anonymous — Thu, 16 Jun 2016 15:15:45 GMT

Hi Harshvardhan,

See attached.

Regards!

Re: Current Year Week vs. Previous Year Week

Fri, 17 Jun 2016 00:38:36 GMT

Thank you Manuel for your help.

is it possible in Qlik sense ?

Dual function not return Same result.

Qlik Sense QlikView

Re: Current Year Week vs. Previous Year Week

Fri, 17 Jun 2016 01:39:45 GMT

Hi Manuel

I like your solution - Dont know why i didnt think about that...

I did it with a group by table.

Hi Harshvardhan Tiwari

See attached.

Kind Regards !

Re: Current Year Week vs. Previous Year Week

Anonymous — Fri, 17 Jun 2016 09:36:09 GMT

Hi,

Try with aggr max:

=Dual(WeekEnd,Aggr(Max(Week),WeekEnd))

Dual function:

dual( s , x )

Forced association of an arbitrary string representation s with a given number representation x. In QlikView, when several data items read into one field have different string representations but the same valid number representation, they will all share the first string representation encountered. This function can be used in scripts and chart expressions.

In scripting, the dual function is typically used early in the script, before other data is read into the field concerned, in order to create that first string representation, which will be shown in list boxes etc.

Regards!