topic Re: Merging dimensions at Dashboard level in QlikView

Merging dimensions at Dashboard level

Thu, 22 Oct 2015 10:23:55 GMT

HI,

How to merge two dimensions into one at dashboard level.

Lets say i have field

Enquiry

ASD

BSD

CSD

and another field

Lead

QWE

WER

So the Final Field should result should be

Customer

ASD

BSD

CSD

QWE

WER

Regards,

Keerthi KS

Re: Merging dimensions at Dashboard level

sunny_talwar — Thu, 22 Oct 2015 10:36:27 GMT

May be this as your calculated dimension:

=ValueList($(=Chr(39) & Concat(DISTINCT Enquiry, Chr(39) &',' & Chr(39)) & Chr(39) & ',' & Chr(39) & Concat(DISTINCT Lead, Chr(39) & ',' & Chr(39)) & Chr(39)))

Re: Merging dimensions at Dashboard level

Thu, 22 Oct 2015 10:44:31 GMT

Hi Sunny,

I cant select from the list if i use this way. That should be like a filter.

Currently i have two dimensions used for a table.

I need single filter for both dimensions.

Regards,

Keerthi KS

Re: Merging dimensions at Dashboard level

Thu, 22 Oct 2015 10:48:19 GMT

The better way is concatenate in the script the two dimensions...

Re: Merging dimensions at Dashboard level

Thu, 22 Oct 2015 10:49:27 GMT

Hi Marcos,

Any other way without concatenating ??

Regards,

Keerthi KS

Re: Merging dimensions at Dashboard level

sunny_talwar — Thu, 22 Oct 2015 10:52:47 GMT

To be able to make selections, I think you will have to do this in the script by concatenating them together.

Re: Merging dimensions at Dashboard level

Thu, 22 Oct 2015 10:59:13 GMT

Sorry, I just know this way or as Sunny said..