Hello,
I'm creating a bar chart. This should display the values of the months from the current year with the values of the samemonths in the past year. However, I can't manage that not all v...
Hi, I feel like a moron, but I can't figure it out myself. I have a report that requires year selection. The final column is the last month of the selected year versus the samemonth in the p...
Hi Everyone I have ticketing application which logs number of calls per month. I have data for 5 years. I want to calculate what variance between calls during same period last year around samemonth...
I have multiple files for each month with same structure. I have concatenated these files and calculated MonthYear from each months file like Jan-18, Feb-18 etc. In these files there are field ID, O...
I’m trying to calculate the prior year’s sales data for the samemonth in Qlik Sense, but I’m running into some challenges. Here’s my current setup:
Data Structure: All sales for each month are g...
...he chart. I would like the selected month to display alongside that samemonth 1 year prior (Example: if Jan/2017 is selected, I would like to see Jan/2016 and Jan/2017 display instead of just Jan/2...
Hi All, I am getting problem in calculating last YearMonth Sales on Selection, I have tried two set expression for that but in both the cases my expression working only when I am not selecting a...
Current Years Current Month Vs Last YearSameMonth Data.qvw (175 KB)
how to calculate previous year sales till current yearsamemonth when only monthtoyear field is available date field is not available in table .
like calculate
jan-22 to jul-22 sales&n...
Hi, I need to calculate last year data - for each month separately (and ideally for totals). Like in pivot below: I use addMonths function but it won't work. My formula is:&n...
...ast_12_Fiscal_Months_YoY_Flag={"1"}>} Sales) As final result I need place "Total Sales YoY" on the same rows with "Total Sales". And I understand that I need to add some aggregation to "Total Sales YoY" to g...
