topic Re: List Box Display in QlikView

List Box Display

Wed, 06 Jan 2016 12:51:23 GMT

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

Re: List Box Display

Wed, 06 Jan 2016 13:26:49 GMT

Dear QV Experts,

Please find enclosed the Test Qvw file.

In dashboard Tab, Only Dollar, Case are available. But in Analysis we have Each too.

So if Each selected, like straight table chart, dollar values to be displayed.

But the list box is linked object, so it is displaying Each.

Can anyone suggest me on this.

Re: List Box Display

Anonymous — Wed, 06 Jan 2016 13:31:52 GMT

You have mentioned in your expression..

see this:

=If(Metrics ='Case',num(Sum(SalesCases),'#,##0'),

If(Metrics ='Dollar',num(Sum(SalesAmt)/1000,'$#,##0'),

If(Metrics ='Each',num(Sum(SalesAmt)/1000,'$#,##0'))))

Here for Dollar and Each...same expression......

QV is doing what you are asking him to do

Re: List Box Display

Anonymous — Wed, 06 Jan 2016 13:33:28 GMT

Dont Forget to mention, if you are not selecting Dollar & Case, then what should come in expression at Dashboard report

Re: List Box Display

Wed, 06 Jan 2016 13:34:02 GMT

That is for Straight Table Chart, but not for List Box.

The List Box Expression is,

=If(Metrics ='Case',num(Sum(SalesCases),'#,##0'),

If(Metrics ='Dollar',num(Sum(SalesAmt)/1000,'$#,##0'),

If(Metrics ='Each',num(Sum(SalesEach)/1000,'#,##0'))))

Thanks,
Sasi

Re: List Box Display

sunny_talwar — Wed, 06 Jan 2016 13:34:52 GMT

What do you want DashBoard tab to display when you have Each selected on the Analysis tab?

Re: List Box Display

Wed, 06 Jan 2016 13:37:03 GMT

Hi Sunny,

Dashboard Tab should display in Dollar, if Each selected in Analysis Tab.

Thanks,

Sasi

Re: List Box Display

Anonymous — Wed, 06 Jan 2016 13:37:23 GMT

may be this?

Re: List Box Display

Wed, 06 Jan 2016 13:38:17 GMT

But the ListBox should be of Linked Object. Because i have more than 10 list boxes in the Original Dashboard.

Thanks,
Sasi

Re: List Box Display

sunny_talwar — Wed, 06 Jan 2016 13:41:15 GMT

May be this:

Just changed the Expression label since the expression itself was displaying dollar only. New Expression Label -> =If(Metrics ='Case','Case', If(Metrics ='Dollar','Dollar', If(Metrics ='Each','Dollar')))

Re: List Box Display

chaudhariv — Wed, 06 Jan 2016 13:44:30 GMT

Hi Shashi,

You can try loading the list box as two different tables as islands. And then refer in expressions.

Hope this helps

Thanks

Re: List Box Display

Wed, 06 Jan 2016 13:44:33 GMT

Thanks Sunny.

But in ListBox, SalesRep should display in Dollar Values too only in Dashboard Tab.

Thanks,

Sasi

Re: List Box Display

Wed, 06 Jan 2016 13:50:33 GMT

The solution required for ListBox, SalesRep.

Though it is Linked Object in both the tabs.

In Analysis Tab, if Selected 'Each' Should display in Each.

In Dashboard Tab, Though there is no 'Each' , should display in Dollar.

Thanks,

Sasi

Re: List Box Display

sunny_talwar — Wed, 06 Jan 2016 13:54:46 GMT

Then change the expression to this:

=If(Metrics ='Case',num(Sum(SalesCases),'#,##0'),

If(Metrics ='Dollar',num(Sum(SalesAmt)/1000,'$#,##0'),

If(Metrics ='Each',num(Sum(SalesAmt)/1000,'$#,##0'))))

Re: List Box Display

Wed, 06 Jan 2016 13:57:35 GMT

Though it is linked object, the same will reflect in Analysis Tab as well.

In Analysis Tab, it should display as Each only.

The issue is very tricky. Can we able to restrict based on Sheet?

Please suggest me.

Thanks,
Sasi

Re: List Box Display

Anonymous — Wed, 06 Jan 2016 13:58:46 GMT

Hi Sasi Kumar

Please find the attachment of qvw file. and let me know if this works as per ur requirment.

Thanks

Varun K

Re: List Box Display

sunny_talwar — Wed, 06 Jan 2016 14:02:05 GMT

Can a sheet even trigger work? See attached

Re: List Box Display

Wed, 06 Jan 2016 14:03:14 GMT

In Analysis Tab, If Each Selected, In SalesRep ListBox should display in Eaches.

In Dashboard Tab, In SalesRep ListBox Should display in Dollars.

Re: List Box Display

Wed, 06 Jan 2016 14:07:08 GMT

Good Idea. But if Case Selected in Analysis Tab, Then in Dashboard Tab, they need to see Case selected right.

Re: List Box Display

Wed, 06 Jan 2016 14:10:43 GMT

Hi Sunny,

I got it.

In trigger event, i used this,

If(Metrics ='Case','Case', If(Metrics ='Dollar','Dollar', If(Metrics ='Each','Dollar')))

It is working now.

Thanks,

Sasi