Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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
Luminary

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
Luminary

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

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