topic Re: Bar chart in QlikView

Bar chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I have three expressions. Is it possible to combine three expressions and form it as a single dimension to use that in a bar chart?

Re: Bar chart

jmvilaplanap — Thu, 29 Jun 2017 13:46:09 GMT

What type of expressions? I would be a concatenation of all three expressions?

Exp1 & Exp2 & Exp3 or Exp1 & ' - ' & ....

Re: Bar chart

Anonymous — Thu, 29 Jun 2017 14:05:08 GMT

These are those expressions I'm using,

1. Count(DISTINCT{<Customer= E(Customer),comparison={'true'},BusFields=P(BusFields),withcond4=P(withcond4),withcond3=E(withcond3),withcond2=E(withcond2),withcond1=E(withcond1),withcond=E(withcond)>}withcond4)

2. Count(DISTINCT{<Customer= E(Customer),comparison={'true'},BusFields=P(BusFields),withcond1=P(withcond1),withcond=E(withcond)>}withcond1)+Count(DISTINCT{<Customer= E(Customer),withcond2=P(withcond2),withcond=E(withcond)>}withcond2)

3. Count(DISTINCT{<Customer= E(Customer),comparison={'true'},BusFields=P(BusFields),withcond3=P(withcond3),withcond2=E(withcond2),withcond1=E(withcond1),withcond=E(withcond)>}withcond3)

How can I combine these three expressions in the script and make it as a single dimension?

Re: Bar chart

prieper — Thu, 29 Jun 2017 14:32:44 GMT

would should be the outcome?

Re: Bar chart

jmvilaplanap — Thu, 29 Jun 2017 14:37:16 GMT

Do you need a single number or three different numbers? 1 (the sum of the three expressions) or 1 - 2 - 3 (a combination of the three expresions)