# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for
Did you mean:
Contributor III

## You need to compare the periods in the table (the table multiple columns)

Hi all.

Can't understand how you can compare two periods in the table without having to select points.

file, example attached.

(the table multiple columns)

1 Solution

Accepted Solutions
MVP

Try this expression for difference:

Sum(TOTAL <Week>[Count(MedicalJournalId)]) - Aggr(NODISTINCT Above(Sum([Count(MedicalJournalId)])), Week)

PFA the application also.

Best,

Sunny

8 Replies
Partner - Specialist

HI

can you explain more ?

Contributor III
Author

Hi,

There is a table,

the first column is the week,

the second is a list of medical offices,

third - the number of works

fourth, we need to calculate the sum for the week

the fifth is to calculate the difference between weeks

goal is to look at the dynamics (gain, loss)

Partner - Specialist

what do you want to achieve ? and what stops you ?

Contributor III
Author

Hello again )

I want

learn to compare the results of the two periods to compare (plus, minus).

Stops

can't understand how the table to choose the data by week and previous week

Partner - Specialist

you have to use a set analysis expression in which you have to specify week =week-1 as condition .

i'm not sure thar i got your point .

do you have a sample file ?

Contributor III
Author

I attach the file !

MVP

Try this expression for difference:

Sum(TOTAL <Week>[Count(MedicalJournalId)]) - Aggr(NODISTINCT Above(Sum([Count(MedicalJournalId)])), Week)

PFA the application also.

Best,

Sunny

Contributor III
Author

Thanks to You, I understood the concept

More positivity and success