topic Re: Greying out fields! in QlikView

Greying out fields!

Wed, 02 Jul 2014 09:55:05 GMT

I have different KPI’S and for each, we have a different set of metrics and dimension.

I have implemented ad hoc reporting i.e. I have created two inline tables,

one for dimension and one for metric and we have two filter based on each, so when user selects any dimension and metric the data should populate accordingly.

Now what I need is, I want to have a dropdown list for all those KPI and when user selects any KPI from list ,

the dimension and metric filter should only show the dimensions

and metrics associated to that KPI ONLY, and all other fields should be greyed out.

Can anyone please help me to implement this

Re: Greying out fields!

sasikanth — Wed, 02 Jul 2014 10:00:31 GMT

Please find the attachment

Re: Greying out fields!

datanibbler — Wed, 02 Jul 2014 10:01:41 GMT

Hi,

generally, you should be able to use the aggr() function, like

>>> aggr([field], [field]) <<<

(the very same fieldname.

-> like, when you have a field "month" and a field "week" (calendar_week), then you can type > aggr(week, week) < and your dropdown_list will contain only the four or five calendar_weeks which are in that month.

Is that kind of what you want?

Best regards,

DataNibbler