Qlik Community

Qlik Sense App Development

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

liulin0102
New Contributor

Why is the result of my expression 0?

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.

37c5d7157dba81a999fd0344f15adec.png

63679fd7324d41271e36e574944eaf7.png

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

1 Solution

Accepted Solutions
Highlighted
arvind1494
Valued Contributor

Re: Why is the result of my expression 0?

Try This

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

5 Replies
arvind1494
Valued Contributor

Re: Why is the result of my expression 0?

Because TxDate is date

and qlik consider date as numeric field not string

Highlighted
arvind1494
Valued Contributor

Re: Why is the result of my expression 0?

Try This

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

liulin0102
New Contributor

Re: Why is the result of my expression 0?

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

MVP
MVP

Re: Why is the result of my expression 0?

Please mark the answer as correct to close the thread

arvind1494
Valued Contributor

Re: Why is the result of my expression 0?

Welcome

Please close the thread