Discussion board where members can get started with QlikView.
Hello,i wa,t to calculate number of entry and departure from this table with addinjg two columns .
Which two columns you are talking about? You mean you want to manually enter the numbers into those columns? Can you elaborate a little and your expected output.
in the screenshot there are two columns "entrée" with two values "0" or "1" and same thing for column "sortie".i want to Make a table in QlikView that shows the number of in and out per month.
IF you can share your sample data it would be easy and quick to give you solution. However, you can try like below:
expressions may be:
= Sum(Aggr(Sum(entrée), YourmonthField))
= Sum(Aggr(Sum(Sortie), YourmonthField))