Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikers,
In the attached Excel sheet you find three straight tables with a different selection. It is showing the inventory on articles where a customer has put an order against. When I'm selecting a Containerno I get extra stock (see column Container) it logically shows a value and amount for the articles that are available in the selected container, like the second table Output.
However, I want my straight table as shown in the below straight table Desired output. So the original expression values shouldn't dissapear and the extra stock from the container should also be visible in the columns Value and Deliverable. I'm using below formula and it works when I don't select any container, but will turn into the second table in the Excel attachment when I do select a container.
=Sum(Aggr(
If(sum({<ArtHasInventory={1}>}OrdAmountOrdered-OrdAmountDelivered)<=
If(GetSelectedCount(Containerno)>=1,sum({<ArtHasInventory={1}>}Container),0)+
sum({<ArtHasInventory={1}>}if(Stock<0,0,Stock)),
sum({<ArtHasInventory={1},Containerno=>}(OrdAmountOrdered-OrdAmountDelivered)*(Price-(Price*Discount/100)),
(If(GetSelectedCount(Containerno)>=1,sum({<ArtHasInventory={1},Containerno=>}Container),0)+sum({<ArtHasInventory={1},Containerno=>}if(Stock<0,0,Stock)))*(Price-(Price*Discount/100)))
,Order,Article))
OrdAmountOrdered-OrdAmountDelivered is the formula of the column To Deliver.
Is this problem solvable (without using Alternative State)?
Thanks in advance!
Pim
How about now?
Would it be possible to share a sample app to trouble shoot this issue?
Preparing examples for Upload - Reduction and Data Scrambling
hello
and what about using identifier 1 in your set analysis so they don't take care of your current sélections ?
i.e : sum({1< ...
Hi Sunny,
See attached. Thanks in advance!
Hi Olivier,
Yes, I've tried that as well.. But unfortunately I've ended up with the same problem that it only showed the values of the selected container and removed the rest
We are trying to fix the Deliverable expression, right?
Containerno is not available for all Article here
Is that how the data is? What is the expected output
I posted a screenshot, let me know if you would like me to delete it.
Deliverable and Value. But I guess it's the same issue. So if we solve the one, we have solved the other
So the containers (shown as containerno in listbox) should increase the value/deliverable when selected, but also show the original values (instead of disapearing).
In the example: the total value should increase with 480 euros and we should be able to see the three new values in the table together with the original values.
The Value disappears because there are a lot of Article where there is no container information available. In my screenshot you will see that there are only 6 articles with container information... is this how you expect the data to be?