Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mgavidia
Contributor

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

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.

1 Solution

Accepted Solutions
sebastiandperei
Valued Contributor

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

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

2 Replies
sebastiandperei
Valued Contributor

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

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
Contributor

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

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

Community Browser