topic Problem in Selection Criteria in QlikView

Problem in Selection Criteria

Fri, 07 May 2010 05:19:17 GMT

Dear All,

How can i check Frequently used selection critieria to be displayed first.

PLease Suggest me with the answer,

With Regards,

Pranav

Problem in Selection Criteria

Fri, 07 May 2010 08:09:48 GMT

Hi Pranav ,

Ideal way if you know what will be maximum selection , then store it as a Bookmark & display .

I dont think there is any mechanism for ranking your search criterias .

Regards,

Bhushan N

Problem in Selection Criteria

Fri, 07 May 2010 09:04:44 GMT

This is an interesting question. Hope the "big guys" jump in on this.

It would need a log file to be maintained as you might only want selections from a certain date range in the past. The sum of logged selections could then be used to create an additional sort column for displaying the list.

Problem in Selection Criteria

Fri, 07 May 2010 10:07:43 GMT

Thanks Bhushan for your Quick Reply

Hope any one will solve the problem which will be helpful for all of us.

Thanks Again....

Regards

Pranav Paul

Problem in Selection Criteria

Fri, 07 May 2010 10:10:04 GMT

Dear Juerg

Can u please tell me in details how to maintain a Log file and Display the Selection criteria

Thanks for ur Quick Reply.

Regards

Pranav

Problem in Selection Criteria

Fri, 07 May 2010 10:33:06 GMT

You could call a macro when users select from the list (Trigger). You would also need to have the settings to allow for writing to the disk. In the macro append to a file the selected value. You can get the selected value with GetFieldSelections(). If users can select multiple items you might want to add each selected field to the log using GetSelectedCount() and subfield().

Can't really think of a good method to keep the log from growing and growing. You could use e.g. logparser (a free Microsoft tool) called by the windows scheduler to take care of this. Add the log date into the log file for this to work.

Problem in Selection Criteria

Mon, 10 May 2010 13:54:14 GMT

Dear Juerg,

If i will Make a log file and attach all the feilds which are selected by the user and then again put the log files, then how will it show the selected feilds in the sorting order...

Please Reply and Sorry to Disturb you...

Please Reply ASAP....

Regards Pranav