Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Multiple columns to form a dimension in a column chart

Hi,

I'm completely new to Qlik Sense, and having trouble displaying data in a column chart. I have a feeling that my data source (Excel spreadsheet) is not structured in an appropriate way. Otherwise, maybe I just don't know how to set it up.

My data looks like:

IDStatusABC
1OpenImpactedImpacted
2OpenImpacted
3OpenImpactedImpacted
4ClosedImpacted

I want to create a column chart which shows A, B, C along the x-asis and the Count of 'Open' IDs that belong to the A, B, C.

So it should appear like:

A = 2

B = 2

C = 1

Is there a way to do this using the data I have?

1 Solution

Accepted Solutions
MVP
MVP

Re: Re: Multiple columns to form a dimension in a column chart

Although for me this is more a QlikView question than a Qlik Sense question, here is my guess:

You can create a load script like this (from memory, check help if it does not work the first time):

CROSSTABLE (Item, Impacted, 2) LOAD ID,

Status,

A,

B,

C

FROM File.xlsx;

Then a measure for your chart like this with a set analysis syntax

Count({< Status = {'Open'}, Impacted = {'Impacted'} >} Item)

Dimension will be "Item".

Miguel

4 Replies
Not applicable

Re: Multiple columns to form a dimension in a column chart

Note that the real data contains more than A, B, C and that all can be 'Impacted' and it is not limited to only 2 (as my example might seem to show)

MVP
MVP

Re: Re: Multiple columns to form a dimension in a column chart

Although for me this is more a QlikView question than a Qlik Sense question, here is my guess:

You can create a load script like this (from memory, check help if it does not work the first time):

CROSSTABLE (Item, Impacted, 2) LOAD ID,

Status,

A,

B,

C

FROM File.xlsx;

Then a measure for your chart like this with a set analysis syntax

Count({< Status = {'Open'}, Impacted = {'Impacted'} >} Item)

Dimension will be "Item".

Miguel

etk
Contributor

Re: Multiple columns to form a dimension in a column chart

Let's say it is a Qlik question and you can do this analysis on both products as they use the same Qlik Engine:-).

Thanks a lot!

Elif.

Not applicable

Re: Multiple columns to form a dimension in a column chart

Thanks heaps! Took me a while to understand the syntax but it makes sense now!

It mentioned something about a synthetic key being created. Is this always normal with crosstables?

Anyway, will mark this is answered. Cheers

Community Browser