static dimension

[dunnalahk123]

Hi,

can some one suggest me  how to make metric name static

for example i have a fact where i have 50 metrics  and i am showing in qlik piviot

what happens  some times is if any user clicks on any filter like country  filter in that "india" what all metrics i dont have data for india in my fact table those metrics is going off.  

i want my metric dimension to be static at any cost.

can some one suggest me here

[dplr-rn · Accepted solution]

Do you mean to say the metrics should not be effected by any filter?

If so 2 approaches.

- disable all filters e.g. Sum({1} Sales) 

- disable only a few filters like country and city e.g. sum({<City=,Country=>}Sales)

[dunnalahk123]

i think its working i will test few conditions and let u know.

thank you so much.

[dplr-rn]

good to hear