Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

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
MVP
MVP

Re: Expression Calculation Help

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
MVP
MVP

Re: Expression Calculation Help

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

Partner
Partner

Re: Expression Calculation Help

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.

Partner
Partner

Re: Expression Calculation Help

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!