I have created the columns from values of fields and showed in the chart as expression. But if new values came in my field , then can it be automatically add to my expression .
As you can see my source table structure is as , but I have make the Region values as columns . Now if any new region comes in my table the can it automatically added to my expression in straight table ?
no what I am saying is that , iam only showing the below table in qlikview , and if in my source , a new value suppose Australia came , so can it be automatically added to my expression , because here India , US , UK are expression and Name is dimension.
Wait... In my example I added Germany to my dataset and it appears as column... You can add some new strings and will see that columns add and hide (if delete some rows)...
Expression always should be defined... So if you do not apply different calculation logic to every new expression, there is no reason to make 2,3,5 or more expressions... But if you're going to apply different formula for every new region this chart definitely requires maintenance...
