QlikView: How to lock dimension value at one place to filter records in all charts on the sheet?
I am loading data from Oracle, and displaying in multiple charts on two QlikView sheets. My need is to visualize data in one sheet (for one set of users) with one value of dimension A, and visualize charts on another sheet with a different value of the same dimension (for another set of users). Since there are over 50 charts on the two sheets, I do not want to add the IF condition in each expression in each chart. Is there a way to (a) either set a value of the dimension in each chart that cannot be changed, or (b) fix value of the dimension in its List Box? Basically, I want to fix one value for dimension A in one sheet, and another value in the other sheet without changing all the expressions, which cannot be cleared by the users. Please advise.