Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Graph with the number of voting...

Goodmorning everyone,
I have the following table :

       

YEARQUAD.ClassSez.ESItaStoGeo
15/15I1AA888
15/16I1AA777
15/16I1AA777
15/16I1AA888
15/16I1AA999
15/16I1AA666
15/16I1AA666
15/16I1AA777
15/16I1AA666
15/16I1AA888
15/16I1AA777

how can I get something like :

  

Disciplina1098765
Ita013430
Sto013430
Geo013430

thank you

1 Solution

Accepted Solutions
MVP
MVP

Re: Graph with the number of voting...

Maybe like this

In your LOAD script:

CROSSTABLE (Disciplina, Vote, 5)

LOAD YEAR, QUAD, Class, [Sez.], ES, Ita, Sto, Geo

FROM YourTable;

LOAD 4+Recno() as Vote

Autogenerate 6;

Then create a pivot table chart, two dimensions, Disciplina and Vote and one expression

=Count(Vote)

Pivot Disciplina to the top.

And disable 'suppress zero values' on presentation tab.

1 Reply
MVP
MVP

Re: Graph with the number of voting...

Maybe like this

In your LOAD script:

CROSSTABLE (Disciplina, Vote, 5)

LOAD YEAR, QUAD, Class, [Sez.], ES, Ita, Sto, Geo

FROM YourTable;

LOAD 4+Recno() as Vote

Autogenerate 6;

Then create a pivot table chart, two dimensions, Disciplina and Vote and one expression

=Count(Vote)

Pivot Disciplina to the top.

And disable 'suppress zero values' on presentation tab.

Community Browser