topic Obverriding selection in QlikView

Obverriding selection

Sat, 24 Dec 2011 07:22:41 GMT

Dear All

I have three date fields order date , planned date , and actual date .

i have made six calendar object respectively for above fields for setting start and end date.

it is perfectly working fine for any selction.

Now , demand of customer

he wanted to selct ball the fields , it is also working fine it data exist ,

but if not , in that case , which field i am selction last is overriding other fields.

but customer wanted tp select it , even data doesnt exist.

example

order date start date 12/12/11

order date end date 15/12/11

planned date start date 12/12/11

planned date end date 15/12/11

actual date start date 22/12/11

actual date end date 25/12/11

when he is selecting last calendar objects , only last field get selcted and above two fields get de-selected.

which is logically correct.

but customer wanted to check whther any order is still pending for delivery and it should come empty in desired selection.

Please help , if it is possible anyhow,

Any suggestion will be appreciated.

Thanks in advance .

Regards

Pramod Kumar

Obverriding selection

Tue, 27 Dec 2011 04:53:05 GMT

whether any manipulation is possible to achieve this

Obverriding selection

disqr_rm — Tue, 27 Dec 2011 05:26:12 GMT

What you would need to do is to break your table into two tables, putting all the date data in second table. So you would create a key in your main table, say Order number, and in second table you would keep the same key. Your second table would look like:

%Key, Date, DateType

ORD1, 10/01/2011, ORDER_START

ORD1, 10/20/2011, ORDER_END

.....

Then this Date field will like with your main Time Line table.

Once this is done, you will be able to use Set Analysis or other methods to filter your data according to what you need.

Hope this helps.

Obverriding selection

Wed, 28 Dec 2011 11:39:55 GMT

I have implemented but not got success.

Please help , if it is possible by macros

Regards

Pramod Kumar

Obverriding selection

Wed, 28 Dec 2011 11:55:03 GMT

Hmm, not sure exactly the best way to achieve what the customer wants in this case, but perhaps one thing to try is to change how you are presenting the date selections.

Instead of using calendar objects for dates, use 3 list boxes for each date: one for year, one for month and one for day,e.g:

Year: 2011, 2010, 2009... etc

Month: Jan,Feb, Mar...etc

Day: 1,2,3... etc

Then, when an order date and panned date range has been selected, the customer can see in the actual date list boxes if there are any white cells in the year, month and day list boxes - if they are all grey, you can see that the order is still pending delivery.

Hope that makes sense!

Re: Obverriding selection

disqr_rm — Wed, 28 Dec 2011 14:58:28 GMT

Can you upload a sample file?

Re: Obverriding selection

Thu, 29 Dec 2011 10:20:59 GMT

I have found something in refrence manual , it is lock/unlock mechanism.

it is working fine for evry field .

whether i can pop up a message if system fails new selection becuase of locked old selection .

@ Rakesh

i am uploading screenshot , because i have to take permission from client before i upload data. So Please dont mind

Regards

Pramod Kumar

Re: Obverriding selection

disqr_rm — Thu, 29 Dec 2011 13:51:14 GMT

I understand. What you could do is upload your sample QVW file after you have scrambled the key fields like customer name, etc.