Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to make bars with different equation on a bar chart?

My problem is that I have to display different bars with different equations on a single bar chart.

For example:- I have 3 fields in my excel sheet. I want to make one stacked bar for each field and show them on the same bar chart.

Please help!

Thanks in anticipation!

9 Replies
ramoncova06
Valued Contributor III

Re: How to make bars with different equation on a bar chart?

can you provide an example of what you want

Not applicable

Re: How to make bars with different equation on a bar chart?

are these going to be 1 dimension  with 3 different expressions or 3 dimensions

can you provide a sample of the excel and/or any qvw you may have started?

Re: How to make bars with different equation on a bar chart?

maybe using

ValueList('bar1','bar2','bar3')

as one (calculated) dimension and

Pick(Match(ValueList('bar1','bar2','bar3'),'bar1','bar2','bar3'),expression1,expression2,expression3)

as expression.

hope this helps

regards

Marco

Not applicable

Re: How to make bars with different equation on a bar chart?

Hi Adam,

There are 5 different dimensions.

Not applicable

Re: How to make bars with different equation on a bar chart?

Hi Ramon,

Sorry for late reply!

Let us say there are 5 different dimensions. Each dimension has it's own segments.

I want to show stacked bars for each 5 dimensions showing their respective segments .

Thanks in anticipation.

Not applicable

Re: How to make bars with different equation on a bar chart?

Hi Webel,

What am I supposed to write in place of bar1, bar2, bar3..

Sample data is following:-

Response id     Quarter       Dimension-1      Dimension-2     Dimension-3

  101                  Q1               Yes                    No                    Yes

  102                  Q1               Yes                    Yes                    No

  103                  Q2               No                      Yes                    Yes

  104                  Q2               No                      No                    No

   105                 Q3               No                      Yes                    Yes

   106                 Q3               Yes                    No                    No

  107                Q3               No                      Yes                    Yes

  108                Q4               Yes                   

   109               Q4               No                                                  Yes

   110               Q4               Yes                    No                         Yes

    111               Q5                                        Yes                         No

  112                 Q5               No                      Yes                        Yes

   113                Q5               Yes                    Yes                         Yes

  114                 Q5                                                           

  115                 Q5               No                       No                         No

I want to show one bar for each dimension. If it can be shown as 5 bars grouped together for one dimension and all three dimensions on one single chart then better.

Otherwise, at least what I need is to show all three dimensions on one single chart. Each bar having it's own equation.

Not applicable

Re: How to make bars with different equation on a bar chart?

Hi Ramon,

I have provided the example of my data in above comment.

Please help!

Thanks in anticipation.

ramoncova06
Valued Contributor III

Re: How to make bars with different equation on a bar chart?

you need to write the name of the dimensions

Not applicable

Re: How to make bars with different equation on a bar chart?

Hi Ramon,

I tried doing that but it didn't work.

Can you please share the QV file using above data?

It will be a great help.

Thanks in anticipation!

Community Browser