topic Re: Detach a expression in chart in QlikView

Detach a expression in chart

markgraham123 — Tue, 12 Jul 2016 15:15:38 GMT

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.

Re: Detach a expression in chart

Gysbert_Wassenaar — Tue, 12 Jul 2016 15:19:39 GMT

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>}.

Re: Detach a expression in chart

sunny_talwar — Tue, 12 Jul 2016 15:21:40 GMT

Ignore selection in ID

Sum({<ID>} Value)

Re: Detach a expression in chart

markgraham123 — Tue, 12 Jul 2016 15:26:16 GMT

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)

Re: Detach a expression in chart

Anonymous — Tue, 12 Jul 2016 15:28:02 GMT

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

Re: Detach a expression in chart

markgraham123 — Tue, 12 Jul 2016 15:32:57 GMT

It worked.

Thanks

Re: Detach a expression in chart

markgraham123 — Tue, 12 Jul 2016 15:33:07 GMT

It worked.

Thanks again sunny bro.

Re: Detach a expression in chart

markgraham123 — Tue, 12 Jul 2016 15:33:16 GMT

Thanks sir