Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

vijetasharma
Contributor III

Cross Tab

Hi,

I need help on one scenario where i have to use cross table for that i need cross tab shown in below image so for how should be my data in excel

Regards,

VijetaCros Table.jpg

6 Replies
senarath
Contributor III

Re: Cross Tab

Hi,

I suppose you are talking about Email, Direct Mail and Speaker Programs. Basically there is no feature as such but still you can handle it.

Filed here you get these should be added as a Dimension. After it drag that column to the header level

OR

you can create a synthetic dimension using Valuelist function.

Synthetic Dimensions - ValueList() (Example)

Attached is a one I had taken previously from community.

thanx

Senarath

vijetasharma
Contributor III

Re: Cross Tab

Thanks for reply but,Can you explain more about how to add adhoc (inline) dimension at qlikview end

senarath
Contributor III

Re: Cross Tab

Add a calculated dimension as below

=Valuelist('Email', 'Direct Mail','Speaker Programs')

So you can give conditions in the expressions as;

=if(Valuelist('Email', 'Direct Mail','Speaker Programs')='Email',sum(field)) and so on


Please refer attached link for further details.

Re: Re: Cross Tab

Have a look at attached application.

Regards

ASHFAQ

vijetasharma
Contributor III

Re: Cross Tab

Hi,

Thanks for the reply

but, I have 3 values in my list and while following same way as you did it is repeating for all the column measures

just find the below expression and suggest where I am missing out,

=if(ValueList('Email','Direct Mail','Speaker Program')='Email',Max([Email Open Rate]),Sum([Direct Mail Sent]),Sum[Speaker Program no of Attendees])

Regards,

Vijeta

senarath
Contributor III

Re: Cross Tab

Hi,

There should be 03 separate expressions for 03 columns that you want;

01.

=if(ValueList('Email','Direct Mail','Speaker Program')='Email',Max([Email Open Rate])

02.

=if(ValueList('Email','Direct Mail','Speaker Program')='Direct Mail',Sum([Direct Mail Sent])

03.

=if(ValueList('Email','Direct Mail','Speaker Program')='Speaker Program',Sum[Speaker Program no of Attendees])


thanks

Community Browser