topic Re: Display Field name Based on Content in QlikView

Display Field name Based on Content

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys.

I have 2 tables splited, one of my tables has a primary key with the name of a instance, my second table has thousands of columns that represent components of this instance, almost all collumns are empty but some of thems have a text called OK, the columns that have content depend of the selection of the primary key, my doubt is how i present only the field that match the content based on the selection of my primary key.

To give a better example i give a example of the table:

Instance	App1	App2	App3	App5	App6
Instance A			OK
Instance B		OK
Instance C				OK	OK
Instance D	OK

I want that when i select the Instance A in my list appears a text objects with the Field name App3.

This is possible?

Re: Display Field name Based on Content

Anonymous — Tue, 29 Aug 2017 19:48:52 GMT

Yes,

If you have a data similar to this

Are you expecting something like this ??

Re: Display Field name Based on Content

vishsaggi — Tue, 29 Aug 2017 19:55:07 GMT

Are you going to use 1000 columns in this? One way to show the columns conditionally is to use write a show condition in expression tab - Conditional checkbox.

Re: Display Field name Based on Content

Tue, 29 Aug 2017 20:20:39 GMT

I expect the following result:

Instance	Component
Instance A	App3
Instance B	App2
Instance C	App5;App6

Re: Display Field name Based on Content

Anonymous — Tue, 29 Aug 2017 20:42:10 GMT

This should be feasible to do using Cross Tab in the script.

Thanks,

Re: Display Field name Based on Content

Tue, 29 Aug 2017 20:45:08 GMT

Perfect,

Thats is what i was looking.

Thanks for your help