topic Re: Expression in QlikView

Expression

evansabres — Fri, 29 Sep 2017 17:23:29 GMT

I have an expression

=SUM({$<promoCDE={"ADULT"},}>}[Net Sold Qty]) * [Ticket Base Price]

I do not get an error message when i enter, however in the table, the result is '-'.

The expected result would be a number.

Do I have the expression formatted incorrectly?

Re: Expression

its_anandrjs — Fri, 29 Sep 2017 17:27:03 GMT

Try this

=SUM( { $<promoCDE= {'ADULT'} } >} [Net Sold Qty] ) * [Ticket Base Price]

Re: Expression

krishnacbe — Fri, 29 Sep 2017 17:28:22 GMT

Try to remove the comma highlighted below and check

=SUM({$<promoCDE={"ADULT"},}>}[Net Sold Qty]) * [Ticket Base Price]

Re: Expression

evansabres — Fri, 29 Sep 2017 17:29:03 GMT

The expression dialogue box gives an error message, 'Error in set modifier expression'

Re: Expression

evansabres — Fri, 29 Sep 2017 17:30:04 GMT

I unfortunately get a result of '-' in the table when I do this

Re: Expression

krishnacbe — Fri, 29 Sep 2017 17:30:45 GMT

Try this

=SUM({$<promoCDE={"ADULT"}>}[Net Sold Qty]) * [Ticket Base Price]

Re: Expression

evansabres — Fri, 29 Sep 2017 17:31:29 GMT

I unfortunately get a result of '-' in the table when I do this

Expression

Re: Expression

krishnacbe — Fri, 29 Sep 2017 17:33:29 GMT

Can you share some sample data or Dashboard to fix the Expression

Re: Expression

its_anandrjs — Fri, 29 Sep 2017 17:34:31 GMT

Ohh this is right

=SUM( { $<promoCDE= {'ADULT'} >} [Net Sold Qty] ) * [Ticket Base Price]

Re: Expression

evansabres — Fri, 29 Sep 2017 17:36:03 GMT

SUM({$<promoCDE={"ADULT"},}>}[Net Sold Qty]) * [Ticket Base Price]

promoCDE = ADULT, NET SOLD QTY is a numeric field, such as 2, where as [Ticket Base Price] is a monetary filed, formatted such as 0.00

Re: Expression

evansabres — Fri, 29 Sep 2017 17:37:09 GMT

I am able to enter the expression, however the result is still '-' in the table when I do this

Re: Expression

krishnacbe — Fri, 29 Sep 2017 17:46:20 GMT

What is the Dimension you have used? Actually the first part of your expression result will be one value and Ticket Base price has many values that is the reason you are not getting the result.

Share some sample data with all dimensions you use and expected Output