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

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
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)