# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for
Did you mean:
Contributor III

## Set Analysis divide monthly value into daily value

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
6 Replies
MVP

What is the expected output you are looking for?

MVP

Maybe using TOTAL qualifier to ignore dimension values? like:

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

Contributor III
Author

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.

MVP

Then try what rubenmarin gave above

Contributor III
Author

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

MVP

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.

Tags
Community Browser