topic Re: Re: Re: Issue with Current selections box value on selection of dynamic buckets created in chart in QlikView

Issue with Current selections box value on selection of dynamic buckets created in chart

Mon, 10 Mar 2014 11:14:05 GMT

Hi Guys,

I have a chart which has a calculated dimension to evaluate buckets in the UI. The dimension expression is -

=if(Aggr(sum(Spend),Vendor)<100, 'Less than 100'),

if(Aggr(sum(Spend),Vendor)<200, '101 to 200'),

'Greater than 200')))

When any bucket is selected by the User, in the current selections box, it displays the Vendors associated with the Buckets (this is correct since our bucket is calculated on the basis on the Vendor amounts).

The expectation is that the Current Selections should show the bucket selected and not the Vendor.

Any ideas to achieve this? Attached is a test app with the expectation.

Re: Issue with Current selections box value on selection of dynamic buckets created in chart

Anonymous — Mon, 10 Mar 2014 15:26:56 GMT

Current Selections shows selections in fields. In your case, the bucket is not a field, hence it is not really selected. The Vendors are.

If you create bucket as a field in the script, it will work as you require.

Re: Issue with Current selections box value on selection of dynamic buckets created in chart

aveeeeeee7en — Mon, 10 Mar 2014 15:43:33 GMT

Hi Developer

Try the Attached Qvw.

Instead of using Calculated dimension you can do calculation in the Backend.

Michael is right as Current Selection Box shows selections done in the fields.

Regards

Aviral Nag

Re: Issue with Current selections box value on selection of dynamic buckets created in chart

Tue, 11 Mar 2014 04:49:02 GMT

Hi Michael / Aviral,

Thank you for your response.

Unfortunately, calculating it at the backend or in the script is not an option since the Chart is intended to be dynamic for any selections made in dashboard. (I might need to create a aggregated table with a lot of dimensions; which will be very complex).

I understand that bucket is not a field and hence will not be readily available in the current selections box. I am looking for some workaround wherein I might get to manipulate on the UI to show the selection of bucket.

Thanks,

Re: Re: Issue with Current selections box value on selection of dynamic buckets created in chart

tresB — Tue, 11 Mar 2014 04:56:23 GMT

You can show the selection in a text box like in sample attached.

Re: Issue with Current selections box value on selection of dynamic buckets created in chart

Tue, 11 Mar 2014 06:28:34 GMT

Hi tresesco,

Appreciate your response and solution.

But the Users specifically want it in the Current Selections Box itself.

I could format the Text Box to merge or overlay on the Current Selections Box. But then it poses other challenges like unavailability of Clear button, etc.

Rgds,

Shantanu

Re: Issue with Current selections box value on selection of dynamic buckets created in chart

Fri, 14 Mar 2014 12:24:52 GMT

Hi,

Anyone got a chance to look into this?

Regards,

Re: Issue with Current selections box value on selection of dynamic buckets created in chart

rustyfishbones — Fri, 14 Mar 2014 12:30:43 GMT

You could add an action to the Text Object to clear selections.

Not ideal but it would sort the clear selections part

Re: Issue with Current selections box value on selection of dynamic buckets created in chart

marcus_sommer — Fri, 14 Mar 2014 14:00:10 GMT

You could split your task in many textboxes and buttons and control this whole per visibility ... not very elegant and it's a lot to fiddle ...

Another idea is to take a pivot and create from the current selections a dynamic dimension (selected field) and the expression showed the selected values. A single action could be triggered per selection any from those dimension-values (field action) - perhaps you could also create several such dynamic dimensions each for another trigger or combine it with an inputfield within an expression.

It won't be a simple task - good luck.

- Marcus

Re: Re: Issue with Current selections box value on selection of dynamic buckets created in chart

marcus_sommer — Fri, 14 Mar 2014 16:29:07 GMT

It's an interesting thing - I have little tried and the pivot itself isn't very complicated but a trigger on field-actions don't work because it's a dynamic dimension. Perhaps there is a way to switch the sheet per link inside a pivot-expression to trigger any action and return to origin sheet. Otherwise you could put buttons over the pivot.

- Marcus

Re: Re: Re: Issue with Current selections box value on selection of dynamic buckets created in chart

marcus_sommer — Mon, 17 Mar 2014 09:11:56 GMT

By using from the current selections as filter to $Field there are also trigger possible.

- Marcus

Re: Re: Re: Issue with Current selections box value on selection of dynamic buckets created in chart

Thu, 11 Sep 2014 15:08:11 GMT

Hi Marcus,

i created a pretty similar version 😉 Have a look:

Current Selection Alternatives or Current Selection Alternatives (QVW)

Re: Issue with Current selections box value on selection of dynamic buckets created in chart

ashfaq_haseeb — Thu, 11 Sep 2014 15:33:41 GMT

Hi,

Check if this helps you.

Current Selection Alternatives

Regards

ASHFAQ