topic Stacked chart with 2 separated variables in QlikView

Stacked chart with 2 separated variables

Anonymous — Mon, 10 Feb 2014 19:35:31 GMT

Hi friends,

Please help me with idea how to make stacked chart with 2 separated variables.

Please find my QV file.

Thanks,

Re: Stacked chart with 2 separated variables

Nicole-Smith — Mon, 10 Feb 2014 19:50:03 GMT

Change your load script to:

CrossTable(Type,Answer,2)

LOAD respondentID, surveyID, [qID_16630_128092_Business travel] as Business, [qID_16630_128093_Leisure travel] as Leisure;

SQL SELECT [respondentID]

      ,[surveyID]

      ,[qID_16630_128092_Business travel]

      ,[qID_16630_128093_Leisure travel]

FROM [aaa_787];

Then on your chart:

Dimension 1: Type

Dimension 2: Answer

Expression: count(Answer)/count(total <Type> Answer)

Example file is attached.

Re: Stacked chart with 2 separated variables

Anonymous — Mon, 10 Feb 2014 20:02:19 GMT

Thanks Nicole.