Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pvanderkolk
Partner - Contributor III
Partner - Contributor III

Keep original values visible after selection

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

1 Solution

Accepted Solutions
18 Replies
sunny_talwar

Would it be possible to share a sample app to trouble shoot this issue?

Preparing examples for Upload - Reduction and Data Scrambling

olivierrobin
Specialist III
Specialist III

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

pvanderkolk
Partner - Contributor III
Partner - Contributor III
Author

Hi Sunny,

See attached. Thanks in advance!

pvanderkolk
Partner - Contributor III
Partner - Contributor III
Author

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

sunny_talwar

We are trying to fix the Deliverable expression, right?

sunny_talwar

Containerno is not available for all Article here

Capture.PNG

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.

pvanderkolk
Partner - Contributor III
Partner - Contributor III
Author

Deliverable and Value. But I guess it's the same issue. So if we solve the one, we have solved the other

pvanderkolk
Partner - Contributor III
Partner - Contributor III
Author

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.

sunny_talwar

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?