topic Re: Set analysis greater than a MIN(Date) in QlikView

Set analysis greater than a MIN(Date)

julioarriaga — Fri, 08 Jun 2018 15:35:21 GMT

Hello,

I'm trying to create a greater than in this expression (which works correctly) but any > location in the = sign gives me nothing:

=SUM({<ConsecutivoFiscal={$(=MIN(ConsecutivoFiscal))}>}Bajas)

Kind regards.

sunny_talwar — Fri, 08 Jun 2018 15:37:24 GMT

May be this

=Sum({<ConsecutivoFiscal = {">$(=MIN(ConsecutivoFiscal))"}>} Bajas)

vishsaggi — Fri, 08 Jun 2018 16:01:40 GMT

can we also write this way Sunny?

=Sum({<ConsecutivoFiscal = {"$(='>'&MIN(ConsecutivoFiscal))"}>} Bajas)

sunny_talwar — Fri, 08 Jun 2018 16:06:26 GMT

Sure .. that is how I usually write, but a lot of the people don't

vishsaggi — Fri, 08 Jun 2018 16:23:37 GMT

I have learnt this from one of your expression in a thread. 🙂

sunny_talwar — Fri, 08 Jun 2018 16:26:14 GMT

I like using what you have specified, but I see this getting used very rarely by anyone else. So, just thought of giving what others use today

vishsaggi — Fri, 08 Jun 2018 16:35:19 GMT

Agree. I have not seen many dev's using such way.