Classic Search

Patric_Nordstrom · ‎2021-12-25

In december 2021 I posted one Visualization tip for Qlik Sense per day until Christmas Eve. Here's the app with more details for each tip. If you liked it, here's more tips in the same s...

kostiskampouris · ‎2017-12-06

...istbox DD/MM/YYYY What I want to achieve is to split the store's row into 3 subrows which the first will show current quantity ,the 2nd the perviou's year's same day quantity and the 3rd the c...

saifuddin · ‎2019-07-28

...ser selection. (works fine) =count({$< Number_Day={'$(=$(vMaxDay))'} >}(People_ID)) --Count People_id for the previous year of the selected year but for the same Number_Day as c...

Troy_Raney · ‎2023-10-06

...he filter panes that look pretty much the same for many years, but now we have lots of more abilities to line them up in a grid mode; we have the histogram mode; we have the compact View mode; you can t...

PK007 · ‎2020-08-21

...ate)))<=$(=Max(num(Date)))"}> } TotalSales) And then same date last year: if(weekday(addyears(max(Date),-1)) = 'Sun' , Sum({<Date={">=$(=addyears(Max(num(Date))-1,-1))<=$(=addyears(M...

asmithids · ‎2016-01-09

Hello, I am creating a straight table to show the current day's sales amount and the same date last year's sales amount with variance by store (see attached screen shot of table layout and data m...

Anonymous · ‎2017-06-09

Hi all, I have a requirement wherein i got to get the sum of values starting from same day last year + 60 days in last year. for example today is 06/09/2017 so i need to get sum(value) from 0...

amien · ‎2016-02-22

As title describes, i would like to compare days with days previous year. Based on the dayname (monday). In a threat on this forum i found this load script line: date(if(weekday(date)-weekday(A...

MacGyver · ‎2023-11-24

...ateranges from 2023 and 2022, to get a full list of days from 20.11. to 26.11. in order to calculate the sales volume on this day (of this year). My last formular idea was this: =d...

jaimeeduardo_gc · ‎2020-08-03

...ales of last year in the same store, same days and same month of i had sales this year, something like this: Id_store Sales 2019 Sales 2020 1 75 158 2 23 367 3...

Classic Search

Search

Search the Community

24 days of Visualization

Last Years same week day

same day last year expression

STT - Visualization Day

Same day, same week, previous year Calc

Show Today's Sales and Same Day Last Year's Sales

Same day last year problem

Compare same day to same day last year (monday wit...

Merge Values from same Dimension - Last Week, This...

Sum sales same days different year