Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Bar chart

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?

4 Replies
jmvilaplanap
Specialist
Specialist

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

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

Anonymous
Not applicable
Author

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?

prieper
Master II
Master II

would should be the outcome?

jmvilaplanap
Specialist
Specialist

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)