Hi, I would like create a chart that shows sales dynamic year over year within year dimension or month dimension. It's quite common as I expect, but I've searched through the resources i.e. Set A...
...arMaxDate); MasterCalendar: Load TempDate as OrderDate, week(TempDate) as Week, Year(TempDate) as Year, Month(TempDate) as Month, Day (TempDate) as Day, ApplyMap('QuartersMap', Month(TempDate), N...
...he last 12 months rolling whilst comparing this years data with lastyears. Does that make sense?
So a monthly bar chart showing each months variance to the year before, across a rolling 12 months.&n...
Hi, I've seen several threads about this subject, but I can't meake this to work in my App. The App is showing hierarchical data by (year, month, Area, Sub-Area, Provider, Location). I j...
I would like to show a line chart with Year Over Yearcomparison of total sales per Month. Years are ranging from 2017 to 2018 and I have a calendar dimension with Year and Month. How can I set t...
Hi all, I'm new to QlikSense and right now I am building a QlikSense Prototype. I am struggling with a year to yearcomparison. I have created a Pivot table As you can see I have 2 c...
Hello,
I have a basic table with sales for customer against yearmonth. How do I compare each month with its own previous month (i.e. Apr vs Mar, May vs Apr etc) ?
Thanks in advance....
I have a line chart that I'm comparing previous years with the current year. I only want to show the past months for the current year. How do I do this? I have variables for the c...