Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My below expression work fine :-
if(
Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)
>=
Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)
,
Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)
)
Recently i have Add sales target table , which i add year = 2017 , Now my table have year =2017 , now my table alway display zero value. if user don't select any value on year.
Since now is still Dec 2016 , all my expression unable to work well , and user need to select year=2016 , then it can work. As system
take max year = 2017.
May i know any solution ?
Paul
Hi Paul,
You can use sheet triggers
Right click on the sheet -> properties-> triggers
i solved as per your need
find in the attachment
my qvw
Hi Paul,
I think your requirement is by default the sheet has to be in selection of current year am i right
Regards
Hemanth
Hi Hemanth
Yes , the sheet need to be current year. After I add my sales target for 2017 , now the system think that current year = 2017 , so no data on the report. Look like I need bear for next 3 week and the issue will be solve by itself.
Paul
Hi Paul,
You can use sheet triggers
Right click on the sheet -> properties-> triggers
i solved as per your need
find in the attachment
Hi Hemanth
Thank you for your advise
For QS I also face the same issue . So user must select year =2016 to view the report .
Paul
Get Outlook for iOS<https://aka.ms/o0ukef>
Sry Paul,
I dnt know about qlik sense check whether it has similar option so and so
Regards
Hemanth
It is okay . QS have extension . User need click on button
Paul
Get Outlook for iOS<https://aka.ms/o0ukef>