List Box Display

[#1]

Dear QV Experts,

I have two sheets in a QVW document.

User Type: Dollar, Case, Each

In One Sheet, i need to display Dollar, Case

In the second sheet, i need to display, Dollar, Case, Each.

I have list boxes, KPI, charts, etc in both the sheets. Based on the selection, the respective value should display.

If selected Dollar, Sales Value in Dollar displayed.

If Selected Case, Sales Quantity in Case displayed.

Whereas in the second sheet, if selected Each, then in that particular sheet, Sales Quantity in Each should display.

Where in the first sheet, it should display Dollar values.

Above all are working fine as expected.

Problem is for the list boxes which are linked objects is converting to Each in the First sheet too.

Are there any ways or Do i need to remove from Linked Object & keep separate List boxes for both the sheets.

=If(Metrics ='Case',num(Sum({$<Date={">=$(CYStartDate)<=$(vMaxDate)"}>} CustomerCases),'#,##0'),
If(Metrics ='Dollar',num(Sum({$<Date={">=$(CYStartDate)<=$(vMaxDate)"}>} CustomerSales)/1000,'$#,##0'),
If(Metrics ='Each',num(Sum({$<Date={">=$(CYStartDate)<=$(vMaxDate)"}>} CustomerEach)/1000,'#,##0'))))

Please suggest me.

Thanks,

Sasi

[sunny_talwar]

Awesome

I am glad it worked. I would suggest closing the thread down if the issues has been resolved by selecting correct and helpful answers.

Best,

Sunny

[sunny_talwar]

I think he wants to keep the list box object linked between the two tabs. By putting them in different states, you kind of broke the link.

[#4]

Thanks Varun.