topic Stack bars behind each other in QlikView

Stack bars behind each other

gerhardl — Wed, 13 Apr 2011 15:27:34 GMT

Hi,

Can anyone help me to get the following chart to display the bars BEHIND each other and not on top. I would like it to display as in the selected "Look" thumbnail (the bottom picture on the Styles Tab.

Thanks,

Stack bars behind each other

Oleg_Troyansky — Wed, 13 Apr 2011 15:43:09 GMT

Let me guess (practicing telepathic connection 🙂 - you have a single Dimension and 2 Expressions, and you wanted your 2 Expressions to get arranged behind each other...

Well, it looks like you can only position multiple Dimensions like this, but not multiple expressions.

If I guessed correctly, what you can do as a work around is - create a synthetic dimension using function ValueList(), and then combined your two expressions into a single expression that's conditioned on the value of the ValueList():

IF (ValueList('M', 'F') = 'M', Expr1, Expr2)

This way, you convert your two expressions into an extra Dimension

Stack bars behind each other

IAMDV — Wed, 13 Apr 2011 16:33:34 GMT

Oleg - Thanks so much for this one. Your telepathic connection is successfull! I need exactly the same solution.

But I can't seem to get around the syntax.

Below is the information :

Dimension Name : TransactionName which contains 2 values (Store Purchaser & Market Purchaser)

2 Expressions : Sum (Amount] and Count (Amount)

I am using the below expressions referring to your previous post...

=IF (ValueList('Store Purchaser', ' Market Purchaser') = 'Store Purchaser', Sum (Amount), Count (Amount))

But I can't seem to get this working.

Your help will be greatly appreciated!

Thanks in anticipation.

Stack bars behind each other

Oleg_Troyansky — Wed, 13 Apr 2011 16:37:03 GMT

This expression assumes that you created a Calculated Dimension with the formula:

=ValueList('Store Purchaser', ' Market Purchaser')

Have you?

Stack bars behind each other

IAMDV — Wed, 13 Apr 2011 16:51:06 GMT

Thank you very much for quick response.

I am completely new to this concept. So please bear with me...

I am using the below code for Dimension :

=ValueList('Store Purchaser', ' Market Purchaser')

And the below code for my expression tab in chart

=IF (ValueList('Store Purchaser', ' Market Purchaser') = 'Store Purchaser', Sum (Amount), Count (Amount))

I had removed everything else... So only one dimension & one expression

Is this right?

Stack bars behind each other

IAMDV — Thu, 14 Apr 2011 09:49:58 GMT

Oleg - Please can you take some time to look into this one?

Many thanks in advance.

Stack bars behind each other

Oleg_Troyansky — Thu, 14 Apr 2011 20:08:32 GMT

Yes - what you described is technically correct. I fail to follow the logic - why do you want to calculate the amount and call it "Store purchase" and then count purchases and call the count "Market Purchase" ?

I'd understand something like this:

Dimensions:

1. Product Category (for example...)

2. ValueList('Amount', 'Number of Purchases')

Expression:

if (ValueList('Amount', 'Number of Purchases') = 'Amount', sum(Sales), count(Sales) )

does it make sense?