Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

static dimension

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

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

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)

View solution in original post

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

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
Creator III
Creator III
Author

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

thank you so much.

dplr-rn
Partner - Master III
Partner - Master III

good to hear