Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

After adding sales target 2017 data , now my SET expression if not select year=2016 , it display null value

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 

1 Solution

Accepted Solutions
hemanthaanichet
Contributor III

Re: After adding sales target 2017 data , now my SET expression if not select year=2016 , it display null value

Hi Paul,

You can use sheet triggers

Right click on the sheet -> properties-> triggers

i solved as per your need

find in the attachment

7 Replies
paulyeo11
Valued Contributor II

Re: After adding sales target 2017 data , now my SET expression if not select year=2016 , it display null value

my qvw

hemanthaanichet
Contributor III

Re: After adding sales target 2017 data , now my SET expression if not select year=2016 , it display null value

Hi Paul,

I think your requirement is by default the sheet has to be in selection of current year am i right

Regards

Hemanth

paulyeo11
Valued Contributor II

Re: After adding sales target 2017 data , now my SET expression if not select year=2016 , it display null value

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

hemanthaanichet
Contributor III

Re: After adding sales target 2017 data , now my SET expression if not select year=2016 , it display null value

Hi Paul,

You can use sheet triggers

Right click on the sheet -> properties-> triggers

i solved as per your need

find in the attachment

paulyeo11
Valued Contributor II

Re: After adding sales target 2017 data , now my SET expression if not select year=2016 , it display null value

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>

hemanthaanichet
Contributor III

Re: After adding sales target 2017 data , now my SET expression if not select year=2016 , it display null value

Sry Paul,

I dnt know about qlik sense check whether it has similar option so and so

Regards

Hemanth

paulyeo11
Valued Contributor II

Re: After adding sales target 2017 data , now my SET expression if not select year=2016 , it display null value

It is okay . QS have extension . User need click on button

Paul

Get Outlook for iOS<https://aka.ms/o0ukef>

Community Browser