Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

raju_insights
Contributor III

Combined Name for 2 columns

Hi Techies,

In a table of 10 fields, I have 2 two fields with a name [Total Calls Inbound] and [Total Calls Outbound].  In Dashboard, I need a filter pane with a name Total Calls. On clicking this filter pane this should show [Total Calls Inbound] and [Total Calls Outbound] to choose the required Total call.

How to achieve this ?

Tags (2)
3 Replies

Re: Combined Name for 2 columns

You can't use two fields as one field. If you need one field with all the values from those two fields then you need to create that field in the Data Load Editor.


talk is cheap, supply exceeds demand
Not applicable

Re: Combined Name for 2 columns

Hi raju_insights,

For this you have to use inline table to create Total Call field and to show [Total Calls Inbound] and [Total Calls Outbound] on the click of Total Call you have to trigger that

if _inlinefield = 'Total Call' or getselectedcount(_Inlinefield)>0 then show another filter on the same place which will contain above Total Calls

Regards,

Deepac Bangarwa

ogster1974
Honored Contributor II

Re: Combined Name for 2 columns

you could create a master dimension of those 2 fields and called it Total Calls but it would bring back all records where total inbound + total outbound = total calls not necessarily an individual record

Community Browser