topic Re: current year in QlikView

current year

lionking15 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have created straight table to show sales of current month,for that i have used expression

=Sum ({$<Year ={$(=YearName(max(Date)))},>} Sales)

But i want to show the label as "current year-year" means if i select 2016 the label should be "current year-2016"

for this what should i write in label???

Thanks!!!!!!!

Re: current year

arulsettu — Thu, 04 Aug 2016 08:42:57 GMT

try this

'Current Year'&GetCurrentSelections(year)

Re: current year

lionking15 — Thu, 04 Aug 2016 08:45:37 GMT

Hi Arul

that syntax is not working

Re: current year

vinieme12 — Thu, 04 Aug 2016 08:49:36 GMT

=Current Year - ' & Year

=Current Year - ' & GetFieldSelections(Year)

, will also work

Re: current year

susovan — Thu, 04 Aug 2016 08:57:49 GMT

Hi Giridhar,

You can also try this below expression.

='Current Year' & Max(Year)

='Current Year' & Year

Re: current year

arulsettu — Thu, 04 Aug 2016 09:05:04 GMT

try this

Current Year - ' & Max(Year)

do you have year filed?

if you dont have

try creating year in script

year(date) as year

Re: current year

Anil_Babu_Samineni — Thu, 04 Aug 2016 09:34:18 GMT

Perhaps This,

VYear = YearName(max(Date),'YYYY')

VYear1 = Sum ({$<Year ={'$(VYear)'},>} Sales)

='Current Year' & '$(VYear1)' & ' ' & GetFieldSelections(Year)

For me This is Working(Try Same Expression)

='There were no sales in the months of ' & Concat(distinct {1<Start_Month=E({$<Start_Month={"=sum(DISTINCT PaidWithTax)<>0"}>}Start_Month)>}Start_Month,',',Num(Start_Month))

&' '&'for '&GetFieldSelections(Shop)