Count is incorrect when 2 conditions are selected, one condition at the time is OK.

[mgavidia]

I am creating my first QlikView document: a Monthly Rental/Vacancies report. Sounds simple enough but I have problems.

I managed to get the right count when I select one option at the time, that is, selecting only Move-ins OR only move-outs.
Selecting both options at the same time generates incorrect results.

For example:

When trying to get total Move-ins and Move-outs for May 2012, the report shows only customers who moved-in AND moved-out during the same month (May). My  manager needs the count of ALL Move-Ins in May and the count of ALL Move-outs (regardless of when they moved-in).

Can somebody point me in the right direction?

Thanks!

Miguel Gavidia

PS: It is also my first post, hopefully I did it right.

[sebastiandperei · Accepted solution]

Hi!

I guess your post is right, but my english is bad!! (Sorry for that)

I've attached your sample, with corrections. If understood, you want that in the MoveIn Graph, only takes the selections of MoveIn. Similar to MoveOut graph.

I did that making independence one each other, with set analisis.

Test and tell me!!

Sebas

[mgavidia]

Sebastian,

I appreciate your reply to help me with this problem.

I reviewed your corrections and ended up making a little adjustment to the new Move-Outs formula:

Sum({<MoveInMonth=, MoveOutYear=>}#MoveOutCounter)

My Move-Outs totals still did not come right, so, I changed MoveOutYear for MoveInYear

By looking at the Move-Ins formula, I figured that's what you meant to put in there.

Once I fixed that entry my totals came out just right.

After checking several entries in this group, I understand that I need to concentrate in learning Set Analysis.

I already found some good suggestions. 

Thank you very much!

Miguel Gavidia