Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Classic Search
Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
- 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.
2,853 results
Sorted by:
2017-11-16
01:58 AM
1 Like
Hi all, Can anyone help me out to show the YTD sales with sample data with 10-15 records? how to achieve this? can anyone give sample script and expressions to get. A...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2009-06-04
04:27 PM
Hello, On my sheet the user can select a year and a single month. The idea is that a then display a dashboard with the Current YTD and the LastYear YTD. But how could i do that, my data is stored o...
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (9)
-
In your situation though, I dont think flags can be used as you want to calculate different YTD, P...
-
...nYearToDate(REPORTING_DATE,$(LAST_WORKDAY_REPDATE_VAR),0,1)=-1,1,0) AS YTDFlag, if(InYearToDate(R...
-
...'m shwing the samethign as when Dec is selected. ex 2009, no month : YTD = 01/01/2009 till 12/31/2...
-
...ear, a single month, and then i what the gauge to display the ytd vs ytd_ly of the selected yead/m...
-
Hi use sum(fieldname) other wise attach ur application here? -Sathish
-
I've seen samples that worked with a REPORT_DATE and so on, but in what i want to achieve my report...
-
At the data level there is no problem, i just don't know how to code the SUM in QV, so that the rig...
-
Hi Harry, To get month you can easily use the MONTH statement in the load script. So, It should lo...
-
Hi u have data on daily basis. That means date(Particular date). base on date u take month and yea...
2016-06-15
03:48 AM
Hi Guru's, I have to calculate Current YTD /Last Year YTD to till date it means Current Year YTD(From Jan-01-2016 to Today) / Last Year YTD( Jan-01-2015 Last Year Same Day).I have used S...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2024-06-04
05:34 AM
3 Likes
I want to calculate the YTD for every given year, as seen in the table.
I have the following formula for the max year. Does anybody have an idea how to adapt the formula so the YTD is c...
- Tags:
- deployment
- ytd
Labels
- Subscribe by Topic:
-
General Question
-
Other
-
QlikView App Dev
Show results in replies (8)
-
...nteracted with oneanother. To eliminate that I left out the dimension and created the formula for YTD: =N...
-
...s YTD, daynumberofyear(Date) as DayNumber and then an expression might be look like: sum({< YTD...
-
...um({<YTD={1}>}[Adjusted NAV]),'##,##%') Deine neue Formel bildet also nur den rot markierten T...
-
YTD formula: =Num((Sum({<Valuationdate={"$(vYearEnd)"}>}[Adjusted NAV])-Sum({<V...
-
Der Tipp war super!! Es klappt wenn ich =YTD auf einem Textfeld eingebe, dann kommt auch das r...
-
Hi @EL_MAR, Check with this: YTD: Num(( Sum({<Year(Valuationdate) = $::Year(V...
-
...ahresanfang berechnet, aktuell summierst du alle [Adjusted NAV] Werte, für die YTD=1 gilt. Da muss also d...
-
...der den entsprechenden Ableitungen. Lass die YTD Bedingung und alle Formatierungen erstmal raus und n...
2017-06-13
11:46 AM
Hi, I'm trying to figure out a simple YTD and previous YTD expression: 1. The year follows the calendar year, so I'm looking for 1/1/17 through 6/13/17 in comparison to 1/1/16 through 6/1...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2019-12-18
07:33 AM
Hi, I have the code below which calculates the current year rolling sales and lasy year rolling sales. i'm not able to do the same for ytd calculation in the same code. i have filter of view with o...
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (7)
-
Current year YTD and last year YTD. Right I'm getting values for rolling. If i select rolling f...
-
...iew filter to get my rolling current year and last year sales aslo current ytd and last year ytd. A...
-
...nd ytd. Now suppose i select rolling from view filtre then in the text object of revenue. i should g...
-
...et current year revenue and last year revenue in the revenue text object. now if i select YTD from v...
-
What would you want to see when you select YTD for Last Year?
-
...rom the filter the values are getting as per requirement. but when i select YTD from filter . only t...
-
I don't know if the attached version can help you. I have replaced the vMin and vMax by current ye...
2024-09-24
07:38 AM
2 Likes
I want to calculate the YTD of different fonds, throughout multiple years.
I currently have a very static formula:
=Num((Sum({<Valuationdate={'29.12.2021'}>}[Adjusted NAV])-Sum({<V...
Labels
- Subscribe by Topic:
-
General Question
-
QlikView App Dev
Show results in replies (4)
-
...hat I build a filter. With that filter activated I can calculate the YTD perfectly. Good advice
-
...aster-calendar you could add daynumberofyear() directly + as YTD flag and also a 0/1 flag of the w...
-
Basically I am trying to have a table ( as seen above ) in which the YTD is calculated for each y...
-
I used that formula: =Num( (Sum({<Valuationdate = {"$(=Date(Max({<Year={2022}>...
2017-09-27
09:07 AM
Hi All I am expecting a chart like below. Dimension: Year Expression: Count(GrossSales_Policy) Now I want to create a YTD chart. Here YTD means the maximumum date in the maximum y...
- Tags:
- set expression
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (7)
-
May be try this Sum({<[Trade Date] = {"=SetDateYear([Trade Date], Max(TOTAL Year)) <= Max(TO...YTD.qvw (27,466 KB)
-
...oth Sheets have Monthly and YTD charts. In sheet A YTD chart I have used 3 expression to a...
-
Alternatively, if you can keep Year as your first dimension and Month as second dimension... this c...
-
Forgot to mention that In YTD the valyues for each month should be accumulative. Actual: 2011 J...
-
! In your Aggr expression what does this signify? (Month,(NUMERIC))) because I have now sorted...
-
The Idea is right now I have Dimension: Year Expression: Count(Policy) For YTD chart I n...
-
Use this if you have QV12 or above Aggr(RangeSum(Above(Sum({<[Trade Date] = {"=SetDateYear([Tra...
2018-11-01
10:42 AM
Hello, I have the table as shown below with YTD and MTD as expressions. MTD = (Current month YTD) - (Previous month YTD). My expression for MTD = YTD - Alt(Above(Total(YTD)), 0). T...
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (4)
-
Once again, I don't really know what the issue is? I see repeating numbers for YTD and MTD.... b...
-
stalwar1, the YTD problem is because of the old qvd file I'm loading before. Now my YTD v...
-
stalwar1 the YTD and MTD are same when filtered by Date, look at this below; But it is c...
-
Here is your example.... didn't need to multiply by Avg(1) because we were using Aggr(). But other ...
2011-06-15
07:48 AM
Hi, I loaded budgetdata from a cross table but when I try to make the YTD the result is 0. This is the set analysis I used: Sum({$<MONTH={"<=(=max(MONTH)"}>} BudgetAmount). I u...
Labels
- Subscribe by Topic:
-
QlikView App Dev