Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Detach a expression in chart

Hi All,

I'm trying to detach one expression in the line chart so that it always shows entire value, whereas other expression varies by selection.

EG:

in the attached example, when i select A, i want one expression to show all ID values but other expression to show all values so i can see trend.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Change the expression to sum({<ID>}Value) or sum({1}Value). To ignore selections in all fields use {1}. To ignore selections only in the field ID use {<ID>}.


talk is cheap, supply exceeds demand

View solution in original post

7 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Change the expression to sum({<ID>}Value) or sum({1}Value). To ignore selections in all fields use {1}. To ignore selections only in the field ID use {<ID>}.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted

Ignore selection in ID

Sum({<ID>} Value)

Capture.PNG

Highlighted
Specialist
Specialist

GD,

When i try the above logic, it just disappears in full value color,

Trying to separate both colors (may be making one a bit transparent..but not working)

Highlighted
Anonymous
Not applicable

as I see each ID has two values

do you want to see both values e.g. when you select ID = A

like this: to achieve this you can define Value as second Dimension and sum(Value) as Expression)

or you the second chart? just promote Value to first place

or how your Chart should look like?^

Highlighted
Specialist
Specialist

It worked.

Thanks

Highlighted
Specialist
Specialist

It worked.

Thanks  again sunny bro.

Highlighted
Specialist
Specialist

Thanks sir