topic Re: Cyclic Group dimension with 2 Charts with 1 expression in QlikView

Cyclic Group dimension with 2 Charts with 1 expression

Anonymous — Tue, 03 Dec 2013 13:54:21 GMT

Need assistance,

My Cyclic Group contains 2 Fileds

1]Revenue

2]Year

And Expression count(X)

while using Cyclic group on Dimension on Select of "Revenue" we need Bar representation 2]On select of Year it has to show trend chart

but expression is same.

InAdvance,

Thank you

Re: Cyclic Group dimension with 2 Charts with 1 expression

jerem1234 — Tue, 03 Dec 2013 14:10:46 GMT

Maybe use a combo chart and have 2 expressions that both have count(X). Then for one expression, use a bar representation, the other a line chart. Then use a calculation condition with something like:

GetCurrentField(YOURGROUP)='Revenue'

for your bar expression and

GetCurrentField(YOURGROUP)='Year'

for your trending expression.

Hope this helps!