Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

zazoukhalil
New Contributor

how could i add two columns enter's number and departure's number ?

Hello,i wa,t to calculate number of entry and departure from this table with addinjg two columns .

3 Replies
vishsaggi
Esteemed Contributor III

Re: how could i add two columns enter's number and departure's number ?

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.

zazoukhalil
New Contributor

Re: how could i add two columns enter's number and departure's number ?

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.

vishsaggi
Esteemed Contributor III

Re: how could i add two columns enter's number and departure's number ?

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))

Community Browser