Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

markgraham123
Contributor II

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.

Tags (1)
1 Solution

Accepted Solutions

Re: Detach a expression in chart

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
7 Replies

Re: Detach a expression in chart

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

Re: Detach a expression in chart

Ignore selection in ID

Sum({<ID>} Value)

Capture.PNG

markgraham123
Contributor II

Re: Detach a expression in chart

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)

hrlinder
Honored Contributor

Re: Detach a expression in chart

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?^

markgraham123
Contributor II

Re: Detach a expression in chart

It worked.

Thanks

markgraham123
Contributor II

Re: Detach a expression in chart

It worked.

Thanks  again sunny bro.

markgraham123
Contributor II

Re: Detach a expression in chart

Thanks sir

Community Browser