topic Selection issues in the field in QlikView

Selection issues in the field

jagannalla — Wed, 07 Jan 2015 15:50:10 GMT

Hi,

In my app I've two fields i.e Product and BusinessDate. When app is opened I want to select MinString value of Product and Max value of business date for particular product. I had written open trigger for this. It is working perfectly. I'm display business dates which belongs to particular product in Multibox using the condition. =If(Product=GetFieldSelections(Product),BusinessDate). So that I can see only dates belongs to particular product which I selected.

Now When user selects another product I want to select Max business date in multibox and also user should be able to select another date for same product.

If you observe carefully max dates are different for each product. And the max date of product A is a possible value of product B.

Please find attached app with sample data.

LOAD * INLINE [

Product, BusinessDate

A, 1/27/2015

A, 1/28/2015

A, 1/29/2015

B, 1/28/2015

B, 1/29/2015

B, 1/30/2015

];

Re: Selection issues in the field

agomes1971 — Wed, 07 Jan 2015 15:57:49 GMT

Hi,

please look at the logic of your inline table data.

Product, BusinessDate

A, 1/27/2015

A, 1/28/2015

A, 1/29/2015

B, 1/28/2015

B, 1/29/2015

B, 1/30/2015

Regards

André Gomes

Re: Selection issues in the field

jagannalla — Wed, 07 Jan 2015 16:00:15 GMT

I didn't get what you said.

Re: Selection issues in the field

agomes1971 — Wed, 07 Jan 2015 16:11:13 GMT

You have different products for the same day...

What is your objective?

André Gomes

Re: Selection issues in the field

jagannalla — Wed, 07 Jan 2015 16:14:50 GMT

I'm not sure about the business level functionality. But we had the data in this level and we need solution as I'm expecting.

Re: Selection issues in the field

tresB — Thu, 08 Jan 2015 05:13:37 GMT

Set a trigger on Product selection. Select date field with search string like:

=Date(Max({<BusinessDate=p({1<BusinessDate>})>}BusinessDate),'M/DD/YYYY')

PFA

Re: Selection issues in the field

sujeetsingh — Thu, 08 Jan 2015 05:23:44 GMT

Selection Triggers will resolve the need.

Re: Selection issues in the field

jagannalla — Thu, 08 Jan 2015 05:30:36 GMT

Hi Tresco,

I went through same solution but expression is different.

my exp: =Date(Max({<BusinessDate=,Product={$(=GetFieldSelections(Product))}>}BusinessDate))

Your exp and my exp is working perfectly. But the think is we are not able to select dates from multibox.

Eg: for B it is 1/30/2015 is max, later I want to select another date which is possible value for that product. Let say 1/28/2015

Thanks,

Jagan

Re: Selection issues in the field

tresB — Thu, 08 Jan 2015 05:35:03 GMT

I guess if you use BusinessDate field directly (no expression) in the multibox, it works fine.

Re: Selection issues in the field

jagannalla — Thu, 08 Jan 2015 05:37:59 GMT

Yes your right, but user want to see only dates belongs to that product only.

Re: Selection issues in the field

tresB — Thu, 08 Jan 2015 06:00:40 GMT

Try this in listbox/multibox:

=Aggr(Only({<BusinessDate>}BusinessDate),Product,BusinessDate)

Re: Selection issues in the field

jagannalla — Thu, 08 Jan 2015 06:04:03 GMT

No help on this also.

Re: Selection issues in the field

tresB — Thu, 08 Jan 2015 06:28:32 GMT

Yes, now I notice that, though it shows only related dates; it doesn't allow selection. Meanwhile, try to teach users about 'Show Alternatives' option in the listbox general tab. That could help identifying the related values.

Re: Selection issues in the field

jagannalla — Thu, 08 Jan 2015 06:43:34 GMT

Hi,

It is good idea, but they need in drop down level to choose dates. We can enable Show Alternatives for listbox but we don't have option for multi box.

Thanks,

Jagan