Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Classic Search
Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
- Qlik Community
- :
- All Forums
- :
- Search
Search
Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
7,980 results
Sorted by:
2017-03-31
01:45 AM
Hello everyone, Im creating a chart which displays the amount of new debtors per month. However, I want to only show the last 12 months in my chart and can't seem to fix it with a dimension limit....
Labels
- Subscribe by Topic:
-
QlikView App Dev
2016-09-26
06:36 AM
Hi. me again. i have quite a few charts and KPIs but for a particular chart, i want to show the last 13 months vols only - as its currently showing all dates. Now i have got a master calendar (w...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2014-09-29
04:56 PM
...olling 12 months only to the last 12 months. This resulted in limiting my result to only the last month. So I tried a few ways to capture the date range: aggr(RangeSum(Above(Sum({$<Year>} {<D...
- Tags:
- data
- date
- rolling_12
Labels
- Subscribe by Topic:
-
QlikView App Dev
2018-02-20
09:18 AM
Hi All, I want to display on last 12 months in the month-year ribbon. In this example Jan-2017 should not be in the list. Could you please help me with the expression to write in the l...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2020-04-06
04:21 AM
Hello, I'm trying to restrict a chart to only show the last 3 months data. I have a simple sum of '$amount' as the expression. This is shown by date (using a master calendar) showing only MM-YYYY 'month...
Labels
- Subscribe by Topic:
-
General Question
-
Layout & Visualizations
-
QlikView App Dev
2023-02-22
09:47 PM
Hi,
I have two columns in my source file and they are in different format. The source file contains more than 12 months of data and I need to filter out these not within last 12 months of the c...
Labels
- Subscribe by Topic:
-
Application Development
-
QlikView App Dev
-
Scripting
2016-11-28
05:45 AM
...ales (Want to display all the record from current date till last 12 month) Could you please advise me how to show all the records by range dimension. the below condition I put on calculated d...
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (4)
-
...ifferent dates. it could be 6 month or last 1 year, based on selected Month and Year. Also want to u...
-
...able? As I mentioned above that current selected Year is 2016 and Month is Aug, So I need to show all t...
-
Again, I am not sure how you are selecting two dates here? I see only a single Year and Month s...
-
Hi, Please first convert month Year filed into mm-yyyy format use this Test: Load *,date(d...
2022-03-28
07:18 AM
Hi community
i am new to qlikview, i want know to show only latest last 3 months records here. can any help
here i have a example table
N...
Labels
- Subscribe by Topic:
-
Application Development
-
Creating Analytics
-
Layout & Visualizations
-
Other
-
QlikView App Dev
-
Scripting
2011-11-23
09:04 AM
...he selected year / month on. E.g.: Year = 2077, Month = Apr, then my x axis shows Nov 06, Dec 06, Jan 07, Feb 07, Mar 07, Apr 07 - If i have no year but just a month selected, the it shows me the last...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2016-12-08
03:13 PM
Hello Qlik Developers I have a bar chart in which i have a dimension called =MonthName(UnitActuals.ReportedDate) I want to show last 13 months and future 6 months data. For example current month...
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (2)
-
Something like this? Then PSA If Expression may cost you the RAM.Instead try writing the S...242789 - show last 13 months and next 6 months.qvw (162 KB)
-
Thanks Arvind. I have achieved this by writing the below expression =if(MonthName(U...