topic Create a Master Dimension item from two fields in App Development

Create a Master Dimension item from two fields

Wed, 17 Aug 2016 16:43:25 GMT

I need to be able to create a master dimension item from two fields in Qlik Sense. I have the following example data:

Call ID: Parent ID:

C1236 C4568

C12345

C1236 C9876

C123 C9876

I need to be able to count the distinct [Call ID] and distinct [Parent ID] and then have this total be used as dimension. I am having difficulty getting this to work. I am able to get a count of the distinct [Call ID] but the fx is not counting the distinct [Parent ID]. I have been trying to use the following expression in a KPI object: Count({<[Liaison Type]={'MSL','FSL'},Objective={'Presentations'},[Product: Description]={'XXX'}>} distinct [Call: Call ID]&'-'&[Parent Call]).

Any suggestions or assistance would be appreciated.

Re: Create a Master Dimension item from two fields

kaushiknsolanki — Wed, 17 Aug 2016 17:04:59 GMT

Hi,

It may be because you are using the distinct for combination of Call ID and Parent ID.

Try this.

Count({<[Liaison Type]={'MSL','FSL'},Objective={'Presentations'},[Product: Description]={'XXX'}>} distinct [Call ID])

Count({<[Liaison Type]={'MSL','FSL'},Objective={'Presentations'},[Product: Description]={'XXX'}>} distinct [Parent Call])

Regards,

Kaushik Solanki

Re: Create a Master Dimension item from two fields

Wed, 17 Aug 2016 19:06:05 GMT

Thanks for the response! This has seemed to work. One additional questions I have. I only want to count [Call ID] when there is not a record in the [Parent ID]. Could you assist with what I would need to add to the script to make this work?