sum to latest month

[alwayslearning]

Hi

I have a field named month which give me data in a dd/mm/yyyy format.  I then have a target column I want to just sum to latest month. i.e. if it is November there will be data for the full year but I want it to just show up to November.

One other thing is that I don't want this figure to change no matter what selection is made by the user from the various Listboxes I have.

Thanks

[alwayslearning]

Hi Shraddha,

Well all the dates will be 1st of the months. As my data actually came from a string value of two separate columns of month and year, which I converted into a dd-mm-yyyy value.

As it is target value, there is data and dates going to end of the year. i.e. there is data in Dec but I would want the expression to sum to just the latest month.

Thanks

[alwayslearning]

Hi Arvind,

I don't have a master calendar in my script for this dashboard.

Can I place this anywhere else in my script?  Or Can you show me a quick way to insert it as I am still fairly new to Qlik so I'm not to sure.

Thanks

[alwayslearning]

Hi Pooja,

Could you put this into context and a qlikview file for me?

As I'm unsure how to raise a flag, or use a created field in the same load area in my script. As I'm still fairly new to Qlik

Thanks