Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart making extra selections

Hi everyone,

I have a chart with a dimension expression as follows:

=IF(UP_DWN_IND<>'U',if(TableType='WUC',MS_WUC5,if(TableType='FGC',FGC,if(TableType='WUC DESCRIPTION',MS_WUC_DESC,if(TableType='HOFNIIN',HOFNIIN,if(TableType='NIIN',NIIN,if(TableType='PARTNO',RMVD_PARTNO,NOMENCLATURE)))))))

TableType is an inline table.  Pretty explanitory.  If FGC is selcted on the TableType listbox, then the chart's dimension will be "FGC", and so forth.  The problem I'm getting is that selections are made for each of the other table types.

Here is a SS of my current selections box, after an FGC drill-down selection is made on my chart

CurrentSelections.PNG

As you can see, the red lines indication extra selections that are made.  I don't want these to be selected.  Take a look at the expression above.  Notice that all the selections correspond to a field within the statement.

Any help would be appreciated.  Thanks.

1 Reply
Not applicable
Author

I tried creating a group for this, but I loose the x-axis scroll bar...