topic Re: Calculated Dimensions in QlikView

Calculated Dimensions

Tue, 14 Jul 2015 07:08:13 GMT

Hi Friends,

load Inlin [

Department,

if(wildmatch(Department,'Comp*','Mec*'),Department) as Dept1,

if(wildmatch(Department,'Elec*','IT'),Department) as Dept2

]

I created two Calculated Columns while I was loading the file. Dimensions are "Dept1,Dept2 ". Now my Problem is I want to show those Columns as Calculated Dimensions in a barchart. Is it Possible....?

In a bar chart 1st bar should be Dept1 and 2nd is Dept2. can you please tell me how is this?

Re: Calculated Dimensions

jonathandienst — Tue, 14 Jul 2015 07:19:34 GMT

Use this:

=if(wildmatch(Department,'Comp*','Mec*'), 'Dept1', if(wildmatch(Department,'Elec*','IT'), 'Dept2'))

Re: Calculated Dimensions

jonathandienst — Tue, 14 Jul 2015 07:21:19 GMT

But I suggest that you add this as a derived field in your load script rather than using a calculated dimension.

LOAD

	Department,
	if(wildmatch(Department,'Comp','Mec'), 'Dept1', if(wildmatch(Department,'Elec*','IT'), 'Dept2')) As Dept,
	...