topic Re: static dimension in QlikView

static dimension

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

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

Re: static dimension

dplr-rn — Tue, 14 Jan 2020 17:21:12 GMT

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)

Re: static dimension

dunnalahk123 — Tue, 14 Jan 2020 17:45:42 GMT

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

thank you so much.

Re: static dimension

dplr-rn — Tue, 14 Jan 2020 19:28:17 GMT

good to hear