Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
jduenyas
Specialist
Specialist

conditional line style/color

Hi all

In my Dimensions > Available Fields/Groups I have a cyclic group that contains 'Periods' (months/days...) and 'Sales-people' as the 2 alternates.

When plotting a line chart against 'Period' dimension, it makes sense to view the chart as a line (and symbol) as it is a continuous dimension. However when selecting 'Sales-People' as dimension, a line chart makes no sense and should be either Column or line with Symbol where only the Symbol is viewable.

Is there a way to show the chart, when 'Sales-People' is the dimension,  and hide the line while showing only the Symbol?

Your help is appreciated.

Thanks

Josh

 

1 Solution

Accepted Solutions
jonathandienst

If you use a combo chart, you can create two expressions and display the one with a line and one with bars, and then use conditional display on the expressions dialog to switch between the two. The GetCurrentField() function will allow you to determine which option is selected in the cyclic.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
jonathandienst

If you use a combo chart, you can create two expressions and display the one with a line and one with bars, and then use conditional display on the expressions dialog to switch between the two. The GetCurrentField() function will allow you to determine which option is selected in the cyclic.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

jduenyas
Specialist
Specialist

Bravo!

Thanks a lot. Nice solution.

 

jduenyas
Specialist
Specialist

Works beautifully