Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
cxclucas
New Contributor III

Can sync expressions between many tables?

Hi there!

My QV has many(like 50) straight tables where expressions are always the same, the only thing it changes is the main dimension. Is there any way of sync expressions so I do a change in ona table this will replicate on the others?  Do you imagine other solution or best practice to avoid this?

I know I can create groups(drill-down/cycle) fore sure will make it easier, but dont know if for so many dimensions it still make sense or if there is a better alternative. Maybe grouping dimension by themes and having less tables but using groups, like Time Table(groupng time dimensions(days, weeks, months)), etc.

Thanks

1 Reply
trdandamudi
Honored Contributor II

Re: Can sync expressions between many tables?

You can create a variable and use that variable in all the straight tables. So at any point of time you want to change the expression you no need to go thru all the tables, but you can change it in one place. See if the attached app helps you..

VariableAsExpression.jpg