New to Qlik, Easy question

[joshrussin]

Hey everyone, it's been a while since I've coded anything. Just need a little refresher. I am simply trying to get some information to show in a textbox on a dashboard I am building. Lets say I wanted to add the sum of Processed_Dash in Mechanical Inspection that are completed from 6/1/2017 and 6/2/2017. What is the correct syntax to pull this information in a textbox expression? Thanks

[MarcoWedel · Accepted solution]

Hi,

one solution might be:

=Sum({$<Program_Dash={'AAA'},Date_Dash={'6/1/2017','6/2/2017'}>} Processed_Dash)

hope this helps

regards

Marco

[Anil_Babu_Samineni]

Does 6/1/2017 and 6/2/2017 are constants, If so Marco solution works like chart, If it is not static then you must build up the dynamic expression that part you have to explain little more

[joshrussin]

This seems to be working, but now the requirements will be needed for yesterday.

I believe this is the correct way to do so, just is pulling up today's data for some reason.

Sum({$<Program_Dash={'Mechanical Inspection'},Date_Dash={'date(Today()-1)'}>} Processed_Dash)

[joshrussin]

I was able to use the today function to get Today's date and retrieve the data using the equation, Using this equation, I need to retrieve yesterday's data, but no data is pulling up. Thanks!

Sum({$<Program_Dash={'Mechanical Inspection'},Date_Dash={'date(Today()-1)'}>} Processed_Dash)