Count if status is open and valid date has been passed

[Fio]

Hello community,

I am developing an App and want to count the quotes if the status is open and the valid date has been passed by today.

The Data looks like this:

Offer ID	Offer Valid to Date	Offer Status
1	01/01/2019	Open
2	31/12/2019	Positive
3	02/01/2019	Open
4	31/12/2019	Open

My expression looks like this after I searched for similar questions in the community:

Count({<[Offer Status] = {Open}>} if([Offer Valid To Date]<= Date(Today()), [Offer ID]))

I also want to do the same with quotes that have the status open and are still valid.

Can you help me please?

Thank you!

[Taoufiq_Zarra]

Hi,

why do you think that's not right?
the first function returns 34 and the second function returns 26!
if not, what are the correct values?

Taoufiq

[Fio]

Hi,

I am not saying it is wrong.

I am saying it is not working for me and asking for reasons why it is not working for me, If I have done something wrong or need to change an option or something like that.

Thanks,

Fio

[Taoufiq_Zarra]

HI,

Ok

can you share your Qlikview file (without confidential information)

cheers,

Taoufiq

[Fio]

Hi,

Thank you for your effort.

Yes, I can share it.

Fio

[Taoufiq_Zarra]

it was just a problem of space in expression !

now it's OK

can you, please, close the topic if it's good fir you and mark the solution for the other users.

cheers,

Taoufiq

[Fio]

Yeah,

It is now working in the test App, but not in my normal App.

Could you explain a little bit more to me what you mean with "it was just a problem of space in expression !"?

Thank you!

Fio

[Taoufiq_Zarra]

🙂

in the measure editor

delete the date : [Offer Valid To Date] and replaced by [Offer Valid To Date] in the wizard by "insert"

sorry i use the french version but it's the same

cheers,

Taoufiq

[Fio]

Thank you for your explaination.

It is now working! Thank you very much for all your help and your patience. 

Cheers,

Fio