Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Help with Alternate States Expression

Hi,

The following expression doesn't work:

sum({Grp1}ItemSalesPrice * Quantity)

it works fine without the alternate state group.

Any idea why?

Thanks!

 

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

what do you mean?
your expression looks fine.
are you sure that your alternate state name match with "Grp1" ?
what is your expected result?

View solution in original post

6 Replies
Highlighted
Partner
Partner

what do you mean?
your expression looks fine.
are you sure that your alternate state name match with "Grp1" ?
what is your expected result?

View solution in original post

Highlighted
Contributor III
Contributor III

Hi,

Yes, the name is correct.

the calculation ( of total price) is  fine without the alternate state.

Thanks..

 

Highlighted
Partner
Partner

could you share a sample app woth mock data to look at?
i don't understand why you are using alternate state in that expression.

Highlighted
Contributor III
Contributor III

Hi,

There are actually two expressions for each state for comparison in a table.

I will try to recreate the issue in order to check whether there is an issue with the  price field.  
thanks for your kind help!

 

Highlighted
MVP & Luminary
MVP & Luminary

"The following expression doesn't work:"

It would be useful if you told us what result you are getting -- eg null, zero, a number different than without the State. 

-Rob

Highlighted
Contributor III
Contributor III

Hi,

The expression works fine. It turned out that the field didn't have values for periods I selected.

Thanks for your trying to help!