Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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)

View solution in original post

5 Replies
Highlighted
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)

View solution in original post

Highlighted
liulin0102
New Contributor

Re: Why is the result of my expression 0?

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

Highlighted
MVP
MVP

Re: Why is the result of my expression 0?

Please mark the answer as correct to close the thread

Highlighted
arvind1494
Valued Contributor

Re: Why is the result of my expression 0?

Welcome

Please close the thread