Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
serg_ysn
Contributor III
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.

Please help

(the table multiple columns)

1 Solution

Accepted Solutions
sunny_talwar

Try this expression for difference:

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

PFA the application also.

Best,

Sunny

View solution in original post

8 Replies
mohamed_ahid
Partner
Partner

HI

can you explain more ?

serg_ysn
Contributor III
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)

mohamed_ahid
Partner
Partner

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

serg_ysn
Contributor III
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

mohamed_ahid
Partner
Partner

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 ?

serg_ysn
Contributor III
Contributor III
Author

Thank you for your attention,

I attach the file !

sunny_talwar

Try this expression for difference:

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

PFA the application also.

Best,

Sunny

View solution in original post

serg_ysn
Contributor III
Contributor III
Author

Thanks to You, I understood the concept

More positivity and success