Determining the value of my projections today, in order to compare with the actual

[James17Martin1]

Hi all,

I am wanting to show the sum of what my projections are up to today, so I can compare them to the actual. My [Gross Collections WB VAF12] is my projected values. I am from an R background so I was thinking of using a 'where' statement but I am unsure how to do this in Qlik. I have attached the chart and a snippet of the code for this section below. I basically want the sum of the total predicted collections up to today.  I am hoping to show the value in a text box.

Thank you in advance.

[Brett_Bleess]

Little difficult for me with what you have provided, about the best I can offer is the Design Blog area to see if you can find something there to help, and maybe the Help link after that:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Loading_data.ht...

I am not a very good developer resource unfortunately, but maybe these two link will get you some info that may be of some help.  Just use the Search box on the Design Blog link to search for things, as I am not exactly sure what you need on this one, but I am betting there are likely some posts there that will help.  The Help link is going to be a bit more tedious, but if you browse the content area, you may run across the topic you need there too.  Sorry I do not have something better for you.

Regards,
Brett

[leoosborne89]

Wow, exploring the correlation between your predictions and the actual outcomes sounds like a fascinating endeavor! I recently stumbled upon Odds96, a top-notch betting platform and online casino in India https://odds96.in/en/casino/lottery . The diverse range of sports events available for betting, including football, basketball, tennis, cricket, and more, truly caught my eye. The seamless mobile compatibility ensures an immersive gaming experience anytime, anywhere. What's particularly enticing is Odds96's gaming lobby, boasting hundreds of games across various categories like slots, roulette, live games, baccarat, jackpot slots, and blackjack.

I was particularly drawn to Odds96's commitment to providing legal functions and catering specifically to casino players and sports bettors in India. The focus on this market segment is evident, offering a unique advantage for those seeking a reliable and enjoyable betting experience. If you're into exploring a world of thrilling sports bets and casino games, Odds96 seems like the perfect go-to platform!