Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Hope you all doing well.
I need to hide/display columns (dimensions & expressions) of a table (simple or pivot) using values from a field in a disconnected table.
Here is a sample LOAD INLINE:
table1:
LOAD * Inline[
Code Garantie, Code Branche, Charge sinistre, Code produit
AS, BS, 10, A10
AC, BC, 20, A20
];
table2:
LOAD * Inline[
Etat sin, Code Branche, libelle branche, produit
Ouvert, BS, Test1, AABB
Ferme, BC, Test2, BBCC
];
Requetes:
LOAD * Inline[
Nom req, colonne
A, Code Garantie
A, Code Branche
A, Charge sinistre
B, Etat sin
B, Code Branche
B, produit
];
Values from field "colonne" of the "Requetes" table represents the fields names of the tables "Table1" and "Table2"..
When I select the value "A" of the field "Nom_req" in a filter pane, I need to display only the columns which have a name equal to the values of the field "colonne"..
Example when I choose value "A" ==> columns need to be displayed are: Code Garantie, Code Branche, Charge sinistre
PS: Table "Requetes" needs to stay disconnected from other tables.
I'm thinking about p() function but I can't get it work
Let me know please
Thank you !
Youssef
@sunny_talwar Could you take a look at this please ?
In an effort to save time, would you be able to share the sample you are working with?
Hi Sunny,
I posted a load inline on the description above.
But I just found a solution to my problem actually, It is based on the ad-hoc technique.
Thank you, Take care !
Its good you found the solution, but for future reference. It is easier to work with a sample qvw or qvf because I don't have to load the data and create front end objects to check what you are trying to do. All those things will require me to spend time. Why not make it easier for people you are seeking help from?
Best,
Sunny
Sorry about that Mr. Next time you'll find everything you need.
Thanks
Youssef