Why is the result of my expression 0?

[Anonymous]

Hi, everyone, I'm a beginner in learning qlik, and on sense desktop I had a problem doing an exercise with an example: when I created a table and wrote an expression in it, my results were different from those in the example, but our scripting language, expressions, and data They are all the same.

and this is my  expression :sum({<TxDate={'2016*'}>} SalesAmount)

[arvind1494]

Because TxDate is date

and qlik consider date as numeric field not string

[arvind1494 · Accepted solution]

Try This

sum({<TxDate={">=$(=makedate(2016,01,01))<=$(=makedate(2016,12,31))"}>} SalesAmount)

[Anonymous]

Thank you very much. Your answer perfectly solved my problem.

[petter]

Please mark the answer as correct to close the thread

[arvind1494]

Welcome

Please close the thread