topic Re: restrict field selection in dropdown in QlikView

restrict field selection in dropdown

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

Hi,

I have a requirement to show the last two years in the dropdown box based on the current selection in the listbox. My problem is the year fields are in the format of FY2015,MY2015..FY stands for full year and MY stands for mid year.

example

if i select FY2016 in the listbox, i wanted to show .MY2016 and FY2015 in the drop down.

Years in order

FY2016

MY2016

FY2015

MY2015

.....

....

can anyone help? attached an example data in the qvw file with explanation about my issue

Thanks

Gautham

Re: restrict field selection in dropdown

gauthamchilled — Thu, 22 Dec 2016 15:41:13 GMT

Any help?

Re: restrict field selection in dropdown

sunny_talwar — Thu, 22 Dec 2016 15:57:01 GMT

May be using a link table:

Data:

Load * inline

[

Country,Sales,Year,Sort

APAC,23456,FY2015,20152

APAC,23436,MY2015,20151

EMEA,287436,FY2015,20152

EMEA,287436,FY2016,20162

EMEA,23456,MY2016,20161

];

LinkTable:

LOAD * Inline [

Sort, Actualsort

20162, 20161

20162, 20152

20161, 20152

20161, 20151

20152, 20151

];

DummyTable:

Load * inline

[

AcutalYear,Actualsort

FY2015 Actuals,20152

MY2015 Actuals,20151

FY2016 Actuals,20162

MY2016 Actuals,20161

];

Re: restrict field selection in dropdown

gauthamchilled — Thu, 22 Dec 2016 16:57:32 GMT

Thanks Sunny, May I know what Aggr(AcutalYear, AcutalYear) will do???

Re: restrict field selection in dropdown

sunny_talwar — Thu, 22 Dec 2016 17:01:18 GMT

If you use ActualYear, you will see all the ActualYear (but greyed out which are not selectable) where as Aggr(AcutalYear, AcutalYear) will show whatever is available for selection. In fact, you should use this =Aggr(Only({<AcutalYear>}AcutalYear), AcutalYear) instead of Aggr(AcutalYear, AcutalYear)

See the comparison here:

Re: restrict field selection in dropdown

gauthamchilled — Fri, 06 Jan 2017 07:23:23 GMT

Is there a way to replace the calculated dimension used in the dropdown as direct field. Because after publishing in server, the dropdown is not appearing because of limitation??

created a new thread here.. Dropdown not working in Ajax

Gautham

Re: restrict field selection in dropdown

sunny_talwar — Fri, 06 Jan 2017 10:18:48 GMT

Responded on your new post