topic Re: Straight Table Issue in QlikView

Straight Table Issue

azmeerrehan — Sat, 13 Jan 2018 20:55:26 GMT

Attached please find the output in a straight table. I would like columns C and D to appear in one line and Column E should be the difference (-47285). Below is the expression I amusing for Column E. available_qty and sum_orders are coming from 2 different data sets. I think there is a way to do it using Aggr . Also please note 2 different dates for both expressions

Please help

sum({<Date = {"$(vMax_Prod_Prod_Date)"}>} available_qty)

sum({<Date = {"$(vMax_Prod_Order_Date)"}>} sum_orders)

Re: Straight Table Issue

sunny_talwar — Sat, 13 Jan 2018 21:44:33 GMT

May be this

If(Len(Trim(D)) > 0,

Sum(TOTAL <A, B, C> {<Date = {"$(vMax_Prod_Prod_Date)"}>} available_qty)

Sum(TOTAL <A, B, C> {<Date = {"$(vMax_Prod_Order_Date)"}>} sum_orders))

Re: Straight Table Issue

azmeerrehan — Sat, 13 Jan 2018 21:48:30 GMT

Ur expression is excluding a row. I dont want to exclude the row but show them in a single row with the difference shown in column D

Re: Straight Table Issue

azmeerrehan — Sat, 13 Jan 2018 21:48:50 GMT

Sorry difference shown in column E

Re: Straight Table Issue

sunny_talwar — Sat, 13 Jan 2018 21:49:34 GMT

Excluding a row? Not sure I understand

Re: Straight Table Issue

azmeerrehan — Sat, 13 Jan 2018 21:52:07 GMT

If u look at the output.png I attached i have 2 rows and the net in column E should be -47825 . Ur expression is simply excluding the -52626

Re: Straight Table Issue

sunny_talwar — Sat, 13 Jan 2018 21:53:09 GMT

I wouldn't think it should... but I don't see what you see . Unless you are able to share something else, I will let some one else try to help.

Best,

Sunny

Re: Straight Table Issue

azmeerrehan — Sat, 13 Jan 2018 23:30:18 GMT

Attached please find the sample qvw and XLS. I would like both rows to be displayed as a single row showing the difference

Re: Straight Table Issue

azmeerrehan — Sat, 13 Jan 2018 23:30:40 GMT

Just uploaded a sample qvw and sample xls

Re: Straight Table Issue

sunny_talwar — Sun, 14 Jan 2018 04:10:24 GMT

For the sample where NAME2 is '-' and not null... try this

=If(NAME2 <> '-', Sum(TOTAL <NO, CODE, NAME1> SUM))