Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Fio
Contributor II
Contributor II

Count if status is open and valid date has been passed

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 IDOffer Valid to DateOffer Status
101/01/2019Open
231/12/2019Positive
302/01/2019Open
431/12/2019Open

 

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!

Labels (3)
17 Replies
Taoufiq_Zarra
Master II
Master II

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

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Fio
Contributor II
Contributor II
Author

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
Master II
Master II

HI,

Ok

can you share your Qlikview file (without confidential information)

 

cheers,

Taoufiq

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Fio
Contributor II
Contributor II
Author

Hi,

 

Thank you for your effort.

Yes, I can share it.

 

Fio

Taoufiq_Zarra
Master II
Master II

it was just a problem of space in expression !

now it's OK

Open.PNG

 

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

 

cheers,

Taoufiq

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Fio
Contributor II
Contributor II
Author

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
Master II
Master II

🙂

in the measure editor Capture.PNG

 

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

Capture.PNG

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

cheers,

Taoufiq

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Fio
Contributor II
Contributor II
Author

Thank you for your explaination.

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

 

Cheers,

Fio