This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
YTD should be calculated as per below in the attached qvf:
May be try this
If(SecondaryDimensionality() = 2, Sum(Aggr(RangeSum(Above(Sum(VALUEs), 0, RowNo())), Region, Country, Year, (Month, (NUMERIC)))), Sum(VALUEs))
Where Month and Year are created in the script like this
Date(CretaeDATE) as CretaeDATE,
Year(CretaeDATE) as Year,
Month(CretaeDATE) as Month,
FROM [lib://desktop/Data (1).xlsx]
(ooxml, embedded labels, table is Sheet1);