And Mode - How to display ONLY JUST the select value

[#1]

Hi All,

I make the And mode on my application and it work very weel but I have a small Big Problem:

So how can I do if I just wan to see ONLY the IDs with the select andmode  value from the listbox AndQuality?

Actualy I get Ids with green or white colors, but I just have ID the have ONLY THE GREEN ONE

I have on the left side the listbox "AndQuality" on the right side I have a Table (Pivot Table or...) and in this table I just wann to have ONLY the ID with the select AndQuality values (Only the green Values)

Correct ID = 899, 969, 970, 1050

Wrong ID = 761, 795,796

Please can somebody help me?

Thank you

Armand

[santhoo_san]

share a sample app.

[PrashantSangle]

Hi,

In provided screen shot 761,795,796 having AndQuality as Polyster

therefore it is reflecting.

Is there any maaping between ID and AndQuality???

Regards

[#4]

Sorry I will explain now better:

I have 3 Tables:

Fact:

Load

ID,

ID_ORMODE

ID AS ID_ANDMODE

ORMODE:

Load

ID_ORMODE,

Quality

AndModeJoin:

LOAD

ID_ORMODE ,

ID_ANDMODE

Resident Fact;

Join(AndModeJoin)

LOAD

ID_ORMODE,

Quality

Resident ORMODE;

AndMode:

LOAD Distinct

ID_ANDMODE,

Quality as AndQuality

Resident AndModeJoin;

DROP Table AndModeJoin;

THANK YOU!

[#5]

Hallo All,

I upload yet the  qvw files 🙂

I wan to display ONLY JUST the Selected Faser = Elasthan, Polyester, Schurwolle, Viskose

for example just the MAETIK5 = 13 or 71 ot 141 or 176

and not display the MAETIK5 = 9

Thank you a lot