Expression by Dimension

[#1]

I wanna display % Growth of Sale as follow the formula : (the current - last month ) / last month * 100 . Dimension is Quarter, Month, Week. Parameter is a store. Like a picture.

I try this expresion for a week but it doesnt work : If(WeekYear='29', (Sum(O_TriGiaBan) - Sum({<WeekYear={'28'}>} O_TriGiaBan))/ Sum({<WeekYear={'28'}>} O_TriGiaBan) * 100)

.I wanna calc all the week in the dimension. Please help me!

[Qrishna]

provide some sample date.

[#3]

I will give you my Qlikview file and you can review detail of file !

[sunny_talwar · Accepted solution]

Working with a Personal Edition of QlikView, and hence prepared my own sample to try and show how this can work. You may need to alter this based on your need and requirement.

Script:

Table:

LOAD *,

  (Rand() * 100000) as Value,

  'A' as Product,

  Week(Date) as Week,

  Month(Date) as Month,

  Year(Date) as Year,

  Ceil(Month(Date)/3) as Quarter;

LOAD Date((Today() + 365) - RecNo()) as Date

AutoGenerate 730;

Concatenate(Table)

LOAD *,

  (Rand() * 100000) as Value,

  'B' as Product,

  Week(Date) as Week,

  Month(Date) as Month,

  Year(Date) as Year,

  Ceil(Month(Date)/3) as Quarter;

LOAD Date((Today() + 365) - RecNo()) as Date

AutoGenerate 730;

Created a Pivot Table with the following information:

Dimensions: Product, Year, Quarter, Month, Week

Expressions:

1) Current Value: =Sum(Value)

2) Previous Value: =If(Above(TOTAL Product) = Product, Above(TOTAL Sum(Value)))

3) % Change: =Sum(Value)/If(Above(TOTAL Product) = Product, Above(TOTAL Sum(Value))) - 1

Screenshot:

Attaching the qvw for your reference as well.

HTH

Best,

Sunny

[#5]

it 's work. But I check Show Partial Sum in Presentation Tab of Chart Properties. And it display the Total Sum (value ) but % Change dont display and the Previous Value dont display, too  . The following picture :

I wanna display all the total % Change and Previous Value. Please help me again

[sunny_talwar]

What partial total would you be wanting to see for the Previous Column???

[#7]

I wanna see Partial total of Previous Value Quarter, or Month.

For example: the Row of Total of Year 2015, the Previous Value will display the Total of Year 2014 , and % Change of 2015 compare with 2014. and the Quarter is same Year...

[sunny_talwar]

On it

[#9]

i am so sorry about this inconvenience. I cant see it ??? Can you show me clearly ?

[sunny_talwar]

Still working on it

Sorry, I haven't done this before and that is why it is taking some time. Will revert as soon as I have a solution for you.

Best,

Sunny