Set Analysis divide monthly value into daily value

[Anonymous]

I am having trouble creating a chart that will track percent to plan by day.  The plan is loaded in a script with fiscal day equal to the last fiscal day of the month.  I am creating combo chart with the Fiscal_Days as dimension.  Using the below as an example, I am trying to create a Plan by day estimate, but i can not get the calculation with Plan in it to show except on day 20 where it is loaded.  

My last failed attempt is : (sum({$<{Fiscal_Days=,Period={'Jan'}>}Plan))/max(Fiscal_Days)

This only appears on Day 20.

For this example, I would like to see the daily plan of $1000 in the graph referencing the above formula. 

Any thoughts??

Period	Year	Fiscal_Days	Sales	Plan
Jan	2018	1	1000
Jan	2018	2	1010
Jan	2018	3	1020
Jan	2018	4	1030
Jan	2018	5	1040
Jan	2018	6	1050
Jan	2018	7	1060
Jan	2018	8	1070
Jan	2018	9	1080
Jan	2018	10	1090
Jan	2018	11	1100
Jan	2018	12	1110
Jan	2018	13	1120
Jan	2018	14	1130
Jan	2018	15	1140
Jan	2018	16	1150
Jan	2018	17	1160
Jan	2018	18	1170
Jan	2018	19	1180
Jan	2018	20	1190	20000

[sunny_talwar]

What is the expected output you are looking for?

[rubenmarin]

Maybe using TOTAL qualifier to ignore dimension values? like:

(sum(TOTAL <Year, Period> {$<{Fiscal_Days=,Period={'Jan'}>}Plan))/max(Fiscal_Days)

[Anonymous]

I'm looking for something like this.  Used excel to show the math easier.  Basically, I want to show all the fiscal days as dimension and bar for Sales and line for calculation of plan by day.  This seems simple, but the coding is not straight forward.  I appreciate the help.

[sunny_talwar]

Then try what rubenmarin gave above

[Anonymous]

I think this works, but i don't understand why.  Can you explain 'TOTAL' and why it needed to reference Year & Period?

[rubenmarin]

TOTAL is used to ignore dimension values, the fields between <> are the dimensions you don't wan't to ignore, in this case year and month.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/define-ag...

If you look at the examples in help link, set analysis can be used to ignore selections, but it doesn't ignores dimension values, TOTAL does that.