topic Re: SETANALYSIS in QlikView

SETANALYSIS

chapil — Wed, 18 Aug 2021 13:11:38 GMT

Hello everyone

I have a question : I want to put 2 conditions in my set analysis and one is compose with a function and it doesn't work

Can someone help me with the write syntax, thanks

So that's my problem : I want to count all the IDs wich has a date_1 null and IDs with date_2>30 days from today

So I wrote this expression which is false :

count ({$< [DATE 1] -={""}, [DATE 2] ={"<= today()-30"}>} [ID])

Thanks for the answer !

joaopaulo_delco — Wed, 18 Aug 2021 13:19:41 GMT

Try this:

count({$<[DATE 1]-={"-"}, [DATE 2]={"<= today()-30"}>} [ID])

Please if it solve the problem mark the post as solution.

stevejoyce — Wed, 18 Aug 2021 13:22:06 GMT

I believe it's your date expression. You can try this:

count ({$< [DATE 1] -={""}, [DATE 2] ={"<=$(=date(today()-30))"}>} [ID])

chapil — Thu, 19 Aug 2021 08:24:09 GMT

Thanks, that's working !

chapil — Thu, 19 Aug 2021 08:26:13 GMT

Thanks a lot, both solutions are working 😉

joaopaulo_delco — Thu, 19 Aug 2021 12:58:23 GMT

Hi @chapil , so, please mark some post as solution.