Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
azmeerrehan
Partner - Creator
Partner - Creator

Straight Table Issue

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)

9 Replies
sunny_talwar

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

azmeerrehan
Partner - Creator
Partner - Creator
Author

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

azmeerrehan
Partner - Creator
Partner - Creator
Author

Sorry difference shown in column E

sunny_talwar

Excluding a row? Not sure I understand

azmeerrehan
Partner - Creator
Partner - Creator
Author

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

sunny_talwar

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

azmeerrehan
Partner - Creator
Partner - Creator
Author

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

azmeerrehan
Partner - Creator
Partner - Creator
Author

Just uploaded a sample qvw and sample xls

sunny_talwar

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

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

Capture.PNG