topic Combining two columns in X-axis in QlikView

Combining two columns in X-axis

Fri, 10 Jul 2015 08:01:21 GMT

Hi Team ,

I am having three columns.Named as project,Application and requirement.One project can contain any no. of application.

P1 APP1 r1

P1 APP1 r2

P1 APP2 r3

P2 APP1 r4

I want to plot (project & Application) in x axis and count(requirement) in y axis.

X-axis Y-axis

P1-APP1 2

P1-APP2 1

P2-APP1 1

I tried concat(project,application).It is not working. Can u please suggest a solution for this?

Re: Combining two columns in X-axis

Gysbert_Wassenaar — Fri, 10 Jul 2015 08:20:46 GMT

Create a new field in the load script that combines the two fields or use a calculated dimension that combines the two fields: project & '-' & Application

Re: Combining two columns in X-axis

Fri, 10 Jul 2015 09:22:10 GMT

Hi Gysbert,

Thank u for the reply.It is working fine.