topic Dynamic Fields in a chart (straight table) in QlikView

Dynamic Fields in a chart (straight table)

Mon, 09 Mar 2015 16:57:01 GMT

Hi there,

I have 2 2 sets of data, one holds the activity detail, the other all the different field data associated to the activity. Problem being that currently the field data is 215 columns wide, not every field is completed for every activity, at the very minumum there is 1, at the very maximum there is about 30.

I want to be able to design something that automatically re-structures a chart (straight table) to only reflect the fields pertinent to that activity Selected in the activity table?

Can Anyone assist?

Thanks

Re: Dynamic Fields in a chart (straight table)

Anonymous — Mon, 09 Mar 2015 17:10:51 GMT

An idea to try:

Create a table with dimension activity id, and all other columns as expressions. Show them conditionally, and the conditions could be something like

len(trim(concat(distinct FieldName,'')))>0

Re: Dynamic Fields in a chart (straight table)

Mon, 09 Mar 2015 17:33:02 GMT

Hi Stephen,

Michael suggestion gonna work but in this situation you will need to create as much expression as you have fields, If I'm not mistaken.

As an option you can prepare inline table which will contain combination of fields for each activity.

In straight table you will define dimensions like =[$(= [vField1])]. Qty of dimensions should be maximum possible fields per activity.

SET vField1 = =subfield(concat(Field, ';'),';',1);

As an addition you will need to prepare hide contention for each in order to avoid empty columns

something like this

GetPossibleCount(Field) >=1 for first dimension

GetPossibleCount(Field) >=2 for second .......

You will just need to play with it, a bit.

Hope it will help