Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pnn44794
Partner - Specialist
Partner - Specialist

Expression Calculation Help

Hello:

 

I'm trying to calculate CPU and Memory amounts, and then sum the totals at the bottom of a straight table.

Neither expression returns any value.  It seems this should be pretty straight forward, but I'm obviously missing something.

 

As always, any and all help is appreciated.  Thanks in advance.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Please post the full context (dimensions and expressions used in your table chart).

It seems like you are just missing an aggregation function in your expressions:

Use Aggregation Functions!

Something like

=Sum(

If(Foundation_2 = 'VSI MEM' and (Foundation_3 = 'VSI Bronze MEM' or Foundation_3= 'VSI Silver MEM'), effective_item_qty * cpu_cores)

)

View solution in original post

3 Replies
swuehl
MVP
MVP

Please post the full context (dimensions and expressions used in your table chart).

It seems like you are just missing an aggregation function in your expressions:

Use Aggregation Functions!

Something like

=Sum(

If(Foundation_2 = 'VSI MEM' and (Foundation_3 = 'VSI Bronze MEM' or Foundation_3= 'VSI Silver MEM'), effective_item_qty * cpu_cores)

)

pnn44794
Partner - Specialist
Partner - Specialist
Author

Hello Stefan:

Thank you for your reply. I will get the info together and post it, but most likely tomorrow (wife is on me to log off ☺ ). I did try your sum expression and when used, I lose the top 20 listing and everything is returned, though it does appear to calculate the MEM and when changed appropriately, the CPU quantities.

pnn44794
Partner - Specialist
Partner - Specialist
Author

Stefan:

 

My apologies.  I apparently started two threads with the same topic and did not mean to.  My fault.  I've solved my problem with Sunny's help.  Here's the response I sent to Sunny in the other thread and again, my apologies.  Not sure how I did that but I did.

 

    ExpertHello Sunny (and Anyone Else Following this discussion):

 

So, I've solved the problem, but it took you (Sunny) to point it out.  In this case, I cannot have an item with three rows where the item_sku is the same.  It just won't work.  So, I eliminated the duplicate item_sku numbers, tweaked my calculated dimensions and expressions and viola!  I'm now getting what I was after which was a top 20 listing by quantity to include the associated CPU and Memory quantities.

 

Many thanks to Sunny for pointing out the conflicts I had between the calculated dimensions and expressions.

 

Sunny, I will mark your last response in that regard as the correct response,  As always my friend, thank you for your assistance.  It's always appreciated.  Happy Holidays!