This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Can't understand how you can compare two periods in the table without having to select points.
file, example attached.
(the table multiple columns)
Try this expression for difference:
Sum(TOTAL <Week>[Count(MedicalJournalId)]) - Aggr(NODISTINCT Above(Sum([Count(MedicalJournalId)])), Week)
PFA the application also.
View solution in original post
can you explain more ?
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)
what do you want to achieve ? and what stops you ?
Hello again )
learn to compare the results of the two periods to compare (plus, minus).
can't understand how the table to choose the data by week and previous week
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 ?
Thank you for your attention,
I attach the file !
Thanks to You, I understood the concept
More positivity and success