topic Re: Single Bar(Stacked) in QlikView

Single Bar(Stacked)

Thu, 04 Apr 2013 11:44:09 GMT

Hi All,

I want to create a single stacked bar chart(attached image for the reference). Is there a way to do that?

I am also attaching the excel data sheet for the reference.

Re: Single Bar(Stacked)

Gysbert_Wassenaar — Thu, 04 Apr 2013 11:53:11 GMT

See attached example

Re: Single Bar(Stacked)

Thu, 04 Apr 2013 13:07:29 GMT

Hi,

please find attached document

Re: Single Bar(Stacked)

Thu, 04 Apr 2013 13:34:00 GMT

Nice Work around..........:) Thanks Gysbert

Could you Please suggest any work around for the displaying % of promotional and non-promotional thing also?

Re: Single Bar(Stacked)

Thu, 04 Apr 2013 14:55:18 GMT

Nice Work around..........:) Thanks amayspatil

Could you Please suggest any work around for the displaying % of promotional and non-promotional thing also?

Re: Single Bar(Stacked)

Gysbert_Wassenaar — Thu, 04 Apr 2013 17:42:10 GMT

See attached qvw.

Re: Single Bar(Stacked)

Fri, 05 Apr 2013 05:50:38 GMT

HeY Gysbert Thanks for the reply, this is what i wanted. But could you please explain the conditional dimension that you have created for the chart?

Thanks in Advance

Arun

Re: Single Bar(Stacked)

Gysbert_Wassenaar — Fri, 05 Apr 2013 08:28:43 GMT

This one?

=dual(Category, FieldIndex('Payment Type',[Payment Type])*10+FieldIndex('Category',Category))

What it does is create a dual value, meaning it has a text value and a numeric value. The text value is just the value of the Category dimension. The numeric value is to sort the categories correctly so the Promotional categories come first and the Non-promotional categories come after that.

Come to think of it, I should have calculated this in the script instead of using a calculated dimension. On the bright side, you get to learn what the fieldindex function does . I've also used it in the expression that assigns the colors to the category segments and in the legend chart so every category will get the same color in both charts.

Anyway, in the qlikview in-memory database every field has a symbol table (see this blog post). The fieldindex function looks up the index number of the value in that symbol table. I use these index numbers to create a number to sort on.

Re: Single Bar(Stacked)

Fri, 05 Apr 2013 08:41:57 GMT

Hey Gysbert

I am not able to understand how did you sort the category data values from this expression:

FieldIndex('Payment Type',[Payment Type])*10+FieldIndex('Category',Category))

Could you please explain this in brief?

Thanks in Advance

Re: Single Bar(Stacked)

Fri, 05 Apr 2013 10:34:46 GMT

Ok......I think i got what you have explained.

So, just for knowledge. Can you please list the scenarios or situation or cases where we should use the following functions:

1.) Dual

2.) FieldIndex

Thanks in Advance

Arun