topic Re: How the selections have no effect in a chart in QlikView

How the selections have no effect in a chart

geogou1973 — Fri, 26 May 2017 07:44:19 GMT

Hello.

I have the following expression in a chart with COMPANY_NAME_HOURLY_CURRENT as dimension

sum(aggr(max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

how can i do selections in COMPANY_NAME_HOURLY_CURRENT that have no effect in the specific chart with this expression.

I tried the following with no result

sum({1}aggr(max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

and

sum({1<COMPANY_NAME_HOURLY_CURRENT=>}aggr(max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

and

sum({<COMPANY_NAME_HOURLY_CURRENT=>}aggr(max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

Also i don't want to use alternate state because the data changes when you change the date in the filter.

Thank you in advance.

Re: How the selections have no effect in a chart

prma7799 — Fri, 26 May 2017 07:59:15 GMT

I think because of this {1} use $ sign to selection

Re: How the selections have no effect in a chart

geogou1973 — Fri, 26 May 2017 08:50:03 GMT

Hello.

Does not work either.

Re: How the selections have no effect in a chart

mayankraoka — Fri, 26 May 2017 18:16:22 GMT

Hi ,

Can you try below expression:

sum({<COMPANY_NAME_HOURLY_CURRENT>}aggr({<COMPANY_NAME_HOURLY_CURRENT>}max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

and

sum({<COMPANY_NAME_HOURLY_CURRENT>}aggr({<COMPANY_NAME_HOURLY_CURRENT>}max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

and

sum({<COMPANY_NAME_HOURLY_CURRENT>}aggr({<COMPANY_NAME_HOURLY_CURRENT>}max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))