topic Re: expression query in QlikView

expression query

didierodayo — Wed, 14 Sep 2016 23:50:29 GMT

Hi ,

I have the expression below and would like to understand the where condition (date=,). What is the return when there is nothing in front of the equal sign. also could this expression be written differently?

Sum({$<Date=,[ADDRESS]={HOME},STREET={LEVIS}>} If(Movedate=Date,[Rentpay]))

Thanks for your help.

Re: expression query

sunny_talwar — Wed, 14 Sep 2016 23:53:02 GMT

date = means that the expression should ignore any selection in date field. What's the reason to re-write the expression? is this not working or slow? Are you trying to get rid of the if statement?

Re: expression query

didierodayo — Wed, 14 Sep 2016 23:57:48 GMT

Thanks Sunny, Yes the chart is quite slow so I am trying to see if there is a better way of writing the same.

Re: expression query

sunny_talwar — Thu, 15 Sep 2016 00:01:50 GMT

‌I think you might be looking to remove the if statement. Is movedate and date both fields? Are you able to share a sample to show how the data looks like?

Re: expression query

didierodayo — Thu, 15 Sep 2016 00:09:30 GMT

Date and Movedate are not always the same. sorry I don't have a sample data atm. the outcome is on a line chart. Thanks

Re: expression query

sunny_talwar — Thu, 15 Sep 2016 00:11:52 GMT

Dummy data which is close to how your actual data looks