Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
alan_grn
Creator II
Creator II

Use field as expression

I have a table that has two fields. one is Report no, the other has a formula in it. (called Formula)

For example Report 1, Sum(Value). Can I use the Formula field as an expression. I keep getting a no data to dipslay error message.

1 Solution

Accepted Solutions
pover
Luminary Alumni
Luminary Alumni

Create a variable that looks like this:

=Formula

Then in the expression of the report put $(Variable). This will expand the formula first and then calculate it.

Regards.

View solution in original post

2 Replies
pover
Luminary Alumni
Luminary Alumni

Create a variable that looks like this:

=Formula

Then in the expression of the report put $(Variable). This will expand the formula first and then calculate it.

Regards.

View solution in original post

alan_grn
Creator II
Creator II
Author

Thanks. It was the = in the formula that was missing.