Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to take difference of time period in dimension

Hi guys,

I am stuck at a position in my project development..I have data in the format below:-

Quarters      A      B     C

   Q1             5      6      7

   Q2              8      9     10

    Q3            10      12   13

   Q4              0         3     0

and i need chart and table in the format as:-

Quarters       X             Y              Z

    Q2-Q1      -               -               -

     Q3-Q2     -               -               -

     Q4-Q3     -               -               -

How do i solve this problem?

1 Solution

Accepted Solutions
perumal_41
Partner - Specialist II
Partner - Specialist II

Hi

in Expression side use this expression

=below(Sum(Value)-Sum(Value)

.Try thsi expression

Regards

Perumal A

View solution in original post

4 Replies
perumal_41
Partner - Specialist II
Partner - Specialist II

Hi

in Expression side use this expression

=below(Sum(Value)-Sum(Value)

.Try thsi expression

Regards

Perumal A

sivarajs
Specialist II
Specialist II

Check the attached file

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

your expression must be

Below(Total Sum(val1))-Sum(val1)

Greetings

Martina

Not applicable
Author

Thanks a lot perumai..