Hi, I am trying to calculate the currentvsprevious Quarter sales means if I select date 3/1/2019 it is 1st march that is Q1 of 2019 year.It should display the comparison of sales for t...
...year. For completed years, that would be "December selected year" vs. "December prev. year" - no problem. But for the current year, we need the last completed month (NOT the current month!) vs. t...
...ser selects a month from filter panel, that month's values and previous month's values to be shown at the same table row. Desired result is like that; I'm sharing very very basic of my data and q...
...he % growth between that year vs its last year, using the same rule (acumulated sales for each month).
I have already tried many solutions here in the topics, but I couldn't get the right result.
F...
...onth, and then show what the previous month was. I have some list boxes with years and months in them to enable me to change which month I'm looking at. In my table, Current Month is just =s...
Hi, I've attached an app. See Sheet 1 In table CurrentvsPrevious, I want to show the Sum of Values for the current month in one column and the Sum of Value for previous Month in another c...
hi, I want to show current week and previous week bar in bar chart I wrote the following expression Current Week : sum({$<Date={'>=$(=Date(WeekStart(Max(Date)),'DD/MM/YYYY'))&l...
...rderDate.autoCalendar={Year}>}Sales) Now I'm having trouble doing it for the previous year total sales KPI that I want to put next to the first one. How do I do it? Thanks in advance.
In Crystal Reports I am able to use the Current() function to get today's date and then I can say Current()-1 to get the previous day. How can I accomplish the same thing in Qlikview:? Better yet, h...
