Working with Maps - Ignore current selection not working in Qliksense

prajnapa — Sat, 16 Nov 2024 02:43:43 GMT

Team,

I have below requirement.

KPI (Annualised Rev)-sum(Revenue)/ no. of quarters.

No. of quaters should only change when user selects Year filter. Otherwise it should all quarters till when we have data availability.

I have a table,

Table A:

Year,KPI,Qtr_count

Table B:

Year, Account Name

When i use below set analysis,

(sum(TOTAL_REVENUE)/SUM( total <Year>{1<KPI_Check={'PMA'},Year = $::Year>}Qtr_Count))

This works fine in all cases except in Map.

Can you help me with this.

Note: In others charts user will pull, Year and KPI (Annualised Rev) then no. of qtrs should be year specific. for all other dimension it should be complete quaters.

topic Working with Maps - Ignore current selection not working in Qliksense in App Development

Working with Maps - Ignore current selection not working in Qliksense