topic Re: Expression Calculation Help in QlikView

Expression Calculation Help

pnn44794 — Fri, 11 Oct 2019 22:17:55 GMT

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.

Re: Expression Calculation Help

swuehl — Sun, 24 Dec 2017 00:32:09 GMT

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)

)

Re: Expression Calculation Help

pnn44794 — Sun, 24 Dec 2017 01:29:31 GMT

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.

Re: Expression Calculation Help

pnn44794 — Sat, 12 Oct 2019 23:30:18 GMT

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.

Hello 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!