Multiple expressions within one table

[rtr13]

Hello,

I am currently on trying to reduce the amount of objects I have in one of my applications and was wondering if there was a way to create one table that allows me to put in separate expressions for each cell in the table. 

In the example above, each text box has a separate expression and columns don't necessarily reference one another. My application has over 200 little text boxes in it (I feel bad for whoever actually made the application) but I am trying to condense these metrics into one table because the application runs pretty slow right now trying to load each box. Is there a way to condense the metrics into one table even if each cell using a different expression?

I appreciate all the help!

Rose

[Arthur_Fong]

There are two requirements here:

1.   Is there a way to condense the metrics into one table even if each cell using a different expression?
2.   The application runs pretty slow right now.

For <1>: 1a) create an inline table with all the expressions required.

                          (eg: Current Year Actual,Current Year Budget,Budget Variance)

                 1b) At front end dimension tab, call the dimension that stores all the expression into the table. 

                        Next go to expression tab,  do

                        pick(match([History Type],'Current Year Actual','Current Year Budget','Budget Variance'),
                                 SUM(TotalClaim),   //exp for Current Year Actual
                                avg(TotalClaim),      //exp for Current Year Budget
                                max(TotalClaim)   // exp for Budget Variance
                          )

                  Refer to qvw attached as reference.

For <2>, take a look at Rob's Document Analyzer

https://community.qlik.com/t5/QlikView-App-Development/Document-Analyzer-V3-0-Update-Available/td-p/...

Thanks and regards,

Arthur Fong

[rtr13]

Would this method allow to make multiple columns as well? 

Some of my tables will need to have different equations in every cell, would this allow for that? You would just add more expressions? 

Thanks!

[Arthur_Fong]

Sure. You can add more expressions.