Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tamagawa
New Contributor

Please advise me on how to draw a bar chart

To whom it may concern,

Please let me know how to draw a following graph and how to set up data.

Rader chart is fine.  I would like to compare how response looks different by profile.

Any recommendation would be highly appreciated.

Look forward to hearing from someone.

Sincerely,

Masako

Tags (1)
1 Solution

Accepted Solutions
pooja_prabhu_n
Contributor III

Re: Please advise me on how to draw a bar chart

Hi,

I used cross tab

Temp:

CrossTable (Q7,Value,1)

LOAD ID,

    Q7A,

    Q7B,

    Q7C,

    Q7D,

    Q7E,

    Q7F,

    Q7G,

    Q7H,

    Q7I,

    Q7J,

    Q7K,

    Q7L,

    Q7M,

    Q7N

FROM

(ooxml, embedded labels, table is Sheet1);

Dimension: Q7, Value

Q.PNG

You can drag and drop the .qvw file into Qlik Sense Desktop or place the file in your use folder.

Thanks,

Pooja

8 Replies

Re: Please advise me on how to draw a bar chart

please post some sample data and your expected result

tamagawa
New Contributor

Re: Please advise me on how to draw a bar chart

Dear Marco-san,

Thank you very much for your support.

Here is the data and I wanted to have a graph in my question.  I would like to compare how answers will be different by profile (ID in the following table).  In Excel, I have to sum up the number who choose what (1~4 and 9 in the following) then draw a bar chart and I can gain the ratio of every choice by item.

Next to this graph, I am going to put another graph which shows the test score in order to indicate how test score related the following answers, let's say the higher the scores, the more likely to choose 5 in Q(uestion)7A etc.

Hope my situation is enough clear.

Thank you very much for your help in deed.

Sincerely.

Masako

   

IDQ7AQ7BQ7CQ7DQ7EQ7FQ7GQ7HQ7IQ7JQ7KQ7LQ7MQ7N
144323334444342
233313333923142
312113123993342
443313423322143
533313333323232
641213444313441
712213333311331
823314424333431
932433332213231
1034424434423133
1122222222222222
1233323423333443
1312111211111141
1443324424433343
1533234234423131
1613213433332149
1742224433321142
1822344444222242
1922212323322242
2034312212312222
:::::::::::::::
:::::::::::::::
:::::::::::::::
pooja_prabhu_n
Contributor III

Re: Please advise me on how to draw a bar chart

Hi,

Refer the attached qvw file.

hope it helps.

Thanks,

Pooja

tamagawa
New Contributor

Re: Please advise me on how to draw a bar chart

Dear Pooja san,

Thank you very much for your time.

I am afraid to say that I could not open your file on my Qlik Sense.

I downloaded your file in Apps < Sense < Qlik on my document and found it in Qlik Sense Desktop hub.

Are there any way I can see your file?

Please fine tune me.

Thank you very much indeed.

With gratitude,

Masako

Re: Please advise me on how to draw a bar chart

You are posting in a forum called "New to QlikView", so it is self-evident that replies contain QlikView examples.

If you want to get Qlik Sense feedback, consider moving your thread to a more appropriate forum (like New to Qlik Sense) by following the instructions outlined here: QlikCommunity Tip: How to move your discussion thread

pooja_prabhu_n
Contributor III

Re: Please advise me on how to draw a bar chart

Hi,

I used cross tab

Temp:

CrossTable (Q7,Value,1)

LOAD ID,

    Q7A,

    Q7B,

    Q7C,

    Q7D,

    Q7E,

    Q7F,

    Q7G,

    Q7H,

    Q7I,

    Q7J,

    Q7K,

    Q7L,

    Q7M,

    Q7N

FROM

(ooxml, embedded labels, table is Sheet1);

Dimension: Q7, Value

Q.PNG

You can drag and drop the .qvw file into Qlik Sense Desktop or place the file in your use folder.

Thanks,

Pooja

tamagawa
New Contributor

Re: Please advise me on how to draw a bar chart

Dear Peter san,

Thank you very much for your feedback.

I post another question in seemingly an inappropriate community so will move it also.

Thank you very much for your guidance.

tamagawa
New Contributor

Re: Please advise me on how to draw a bar chart

Dear Pooja san,

Thank you very much for your continuous support.

I am afraid that yesterday and also today I opened your file from my document but there are no data on Qlik sheet.

I am wondering if you suggest me to unpivot the table and will try.

Arigato gozaimasu.

Community Browser