Show info in a bar chart based on period selection

[danialier]

Hello,

I have the attached QV document with a bar chart showing revenues and shipments in Y axis and period in X axis.

I want the columns (revenues or shipments) to be showed based on the period selection which is a cyclic group so I can move from Quarters to Months. When I select "month" I want the bar chart to ONLY show the bars related to revenues. However when I select "quarter" i want the bar chart to ONLY show the bars related to shipments.

How I can do that ?

Thanks,

dani

[#2]

Hi,

Why don't you make a group with the metrics also? If I didn't misunderstand you only want to show one metric.

Cheers!

[danialier]

Hi,

Yes i just want to show ione metric based on the period selection but I don't know how to do that. I also don't know how I can do that by making a group with the metrics ?

Thanks,

dani

[#4]

Hi,

Just drag and drop one metric to the other in chart properties->expressions tab and you will do cyclic group.

Cheers

[sudeepkm]

Please find the attachment.

[maxgro · Accepted solution]

use conditional expression with this expression (month or quarter, depends on expression)

if(GetCurrentField("period")='month',1,0)