Is it possible for a text box ??

[kkkumar82]

Hi Qlikers,

I am going through a strange requirement, I am straight table with Product->Supplier hierarchy and their spend and savings%.

Here the requirement is when I select a supplier , in a text box I want to display the

1. The top% of a supplier for each  product where the selected supplier should be a member.

   I have achieved to display the list of suppliers along with the other suppliers using indirect set analysis in the straight table but was not

   successful in displaying in text box.

For help I am attaching a Excel file , and it is a snapshot where select MMM supplier and the values in the green should be displayed in the text box with the associated supplier name.

Note: My initial doubt was whether we can get a break down of values in a text box

Thanks

Kiran Kumar

[sunny_talwar]

Not sure if I completely understand your question. Are you trying to ask if we can show multiple values in a text box object?? If that's what you are trying to ask, then yes you can, but I don't seem to understand that logic behind showing the green colored numbers (how are they related to MMM supplier?)

[kkkumar82]

Hi Sunny,

If you see in the excel file MMM supplier is present in the first four products and if I select in the list box MMM supplier then a text box should display the top supplier savings% along with the supplier name .

so in my example the text box should show only the four top suppliers % along with their name because the last product doesn't have MMM as a supplier.

Hope you have understood.

Thanks

Kiran Kumar

[sunny_talwar]

This:

Expression:

=Concat({<Supplier = ,Product = {$(=Concat(DISTINCT {<Product -= e(Supplier)>} Chr(39) & Product & Chr(39), ','))}>}Aggr(

  FirstSortedValue({<Supplier = ,Product = {$(=Concat(DISTINCT {<Product -= e(Supplier)>} Chr(39) & Product & Chr(39), ','))}>}Supplier, -Savings) & ' - ' &

Num(FirstSortedValue({<Supplier = ,Product = {$(=Concat(DISTINCT {<Product -= e(Supplier)>} Chr(39) & Product & Chr(39), ','))}>}Savings, -Savings), '#.00%'), Product), Chr(10))

[kkkumar82]

Thanks Sunny,

Adding to the requirement,

Can we include any if conditions to this. Actually all these conditions must be executed for each product category(I minimized my requirement in my post)

1.  Compare average product savings % and Best Savings from Top 5 competitors in the same product

2.  Choose the higher % savings from 1

                  If average product savings % = Best savings from top 5 competitors in the same product then use average Product                           savings % and

3.

If Supplier Product savings % is < 2 and 2 = average Product savings % then

O -  If Supplier can meet average memory (Product name) savings (X%) then incremental savings of $Y can be accomplished 
                  L -  Supplier is not even meeting the average memory (Product name) savings and need to step up savings performance
Supplier  needs to improve performance to increase share of memory (Product name) TAM ($X)

4. If Supplier Product savings % is < 2 and 2 = Best savings % from top 5 competitors in the same Product then

O -  If Supplier can meet the best savings (X%) of the top 5 competitors in memory (Product name) Product then an incremental savings of $Y can be accomplished 
                  L -  Supplier needs to step up savings performance to get to the best savings performance of top competitors
                  Supplier has the opportunity to increase share of memory (Product name) TAM ($X)

5. If  Supplier Product savings % is >= 2 then

If spend growth for supplier  is > 5 in that Product
                  L -  Supplier needs to improve their savings based on the increased business they expect in the next 4 quarters
                  Supplier has the opportunity to increase share of memory (Product name) TAM ($X)

If spend growth for supplier  is < 5 in that Product
                  L – Supplier has opportunity to increase share of memory (Product name) TAM ($X)                  

[sunny_talwar]

Wow its a huge list of requirement you have got here . I will have to see if I comprehend them before I think about implementing them

[kkkumar82]

Hi Sunny,

Any help or idea that you can give.

Thanks

Kiran Kumar