Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

skhosrow
New Contributor

Grouping Dimensions - Multiple Fields

Hi all,

I am trying to achieve a grouping of a dimension with multiple rules. I am basically trying to create a new grouped dimension (influence) which has a field (Digital Influence). This digital influence field will be made up of pick up all values when the product name is "Metro" or "wave" and the campaign code field is empty.

So far I have tried multiple versions of the following script. Loading an Inline table with the new field name (influence) and two existing fields (product and campaign).

Programmes2:

LOAD * Inline [

Influence, Product, CAMPAIGN

Digital Influence, "METRO", "NULL"

Digital Influence, "WAVE", "NULL"

];

Help would be appreciated!

Thanks,

Shay

Tags (1)
3 Replies
alexantone
Contributor

Re: Grouping Dimensions - Multiple Fields

hello

I wish you could try with a mapping and an apply map on the resident table?

skhosrow
New Contributor

Re: Grouping Dimensions - Multiple Fields

Hi Alexandre,

sorry, could you provide an example of this?

ychaitanya
Contributor III

Re: Grouping Dimensions - Multiple Fields

What is the problem that you are having with the Current Approach of having Inline load with those 3 field names ?

you can use the Nested IF Statements for multiple conditions to derive the dimension (influence)  as well right ?


Thanks

CY

Community Browser