Formula in a field

Mon, 19 Jul 2010 18:02:57 GMT

Hi, I am trying to do something I thought would be easy:

I have Accounts and Values. For some accounts, I want to show sum(Values). For others, I have some other calculation. I thought I could add those in an Excel file and load them such as:

Account ID	Calculation
A100	sum(Values)
A200	avg(Values)
A300	total(Values)

Now, in my tablebox, I have Account ID as a dimension and Calculation as an Expression. This shows me the text entered in Calculation. Is there a way to have it interpreted the formula?

Thanks and regards

Formula in a field

Mon, 19 Jul 2010 18:51:41 GMT

It's not possible to do. It is breaking some chart concepts. Think about how QV should calculate a total result for the Calculation column if you check Expression Total. You should have just one explicit formula. In your case I would use IF, like this:


if([Account ID] = 'A100', sum(Values),
if([Account ID] = 'A200', avg(Values), sum(total Values)))

topic Formula in a field in QlikView

Formula in a field

Formula in a field