Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
anilnaidu13
Contributor

Cyclic Group dimension with 2 Charts with 1 expression

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

1 Reply
jerem1234
Valued Contributor II

Re: Cyclic Group dimension with 2 Charts with 1 expression

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!