Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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?

Labels (1)
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)