topic Re: Multiple expressions within one table in QlikView

Multiple expressions within one table

rtr13 — Sat, 16 Nov 2024 02:01:40 GMT

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

Re: Multiple expressions within one table

Arthur_Fong — Wed, 06 Nov 2019 00:22:09 GMT

There are two requirements here:

Is there a way to condense the metrics into one table even if each cell using a different expression?
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/1159895

Thanks and regards,

Arthur Fong

Re: Multiple expressions within one table

rtr13 — Thu, 07 Nov 2019 15:02:36 GMT

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!

Re: Multiple expressions within one table

Arthur_Fong — Thu, 07 Nov 2019 15:23:48 GMT

Sure. You can add more expressions.