topic Selection Across Fields (not in expression or script) in QlikView

Selection Across Fields (not in expression or script)

robert99 — Fri, 11 Apr 2014 06:27:31 GMT

I'm sure there is a simple way to do this but I can not get it to work

And I know it is possible to either (which I have done until now)

Set this up in an expression (as say sum (if (OrderDate>DueDate etc) or set up in script as a selectable / clickable field

But what I would like to do to make a selection as (to appear in the current selection box)

OrderDate > DueDate

I have not been able to get this to work

Thanks for any help

Re: Selection Across Fields (not in expression or script)

sujeetsingh — Fri, 11 Apr 2014 06:33:27 GMT

Did not get you can you please explain in detail or provide sample .

Re: Selection Across Fields (not in expression or script)

Fri, 11 Apr 2014 06:39:49 GMT

In script write the expression as

sum (if (OrderDate>DueDate etc)) as Selection

and take the 'Selection' field in in list box.

So whenever u will select the list box it will also display the value in current selection box.

Hope this will help you..!

Re: Selection Across Fields (not in expression or script)

robert99 — Fri, 11 Apr 2014 06:40:31 GMT

I have an OrderDate field and a DueOrder field (for an order)

These are in separate fields

I can set up an expression in a chart Count (if (OrderDate > DueDate) OrderNumber

to list these

But I would sooner just make a selection as required. So all charts and tables would be filtered by this selection

Thanks

Re: Selection Across Fields (not in expression or script)

MK_QSL — Fri, 11 Apr 2014 06:43:46 GMT

In your script add like below...

IF(OrderDate > DueDate, 1, 0) as SelectionFlag

Now you can use this flag to count number of orders having OrderDate > DueDate

COUNT({<Flag = {1}>}Distinct OrderID)

Hope this helps..

Re: Selection Across Fields (not in expression or script)

robert99 — Fri, 11 Apr 2014 06:43:56 GMT

Thanks

I could do this but I don't want to include this in script if possible. Or in an expression

Re: Selection Across Fields (not in expression or script)

Fri, 11 Apr 2014 06:45:23 GMT

So do u want to display 1 listbox where u want to display Order Number where

OrderDate > DueDate condition is satisfied.

and based on this order nuber selections u want to filter the data??

Correct if my understanding is wrong..

Re: Selection Across Fields (not in expression or script)

robert99 — Fri, 11 Apr 2014 06:48:49 GMT

Thanks

The reason why I do not want to do this (this time) in script is because the fields are in different unjoined tables. I know I can join tables or use mapping etc but already the script ahs become messy

I'm just trying to tidy up the script and reduce my script if possible. This would be one way to do it

Re: Selection Across Fields (not in expression or script)

MK_QSL — Fri, 11 Apr 2014 06:53:20 GMT

In this case, your sample apps or data file would be helpful to give you quick answer..

Re: Selection Across Fields (not in expression or script)

robert99 — Fri, 11 Apr 2014 07:09:03 GMT

I'm off to work and will explain more when I arrive if required

But what I want is simple (yet I can not see how it is done) that I do not seem to be explaining it that well

If I have

Order Number Order date DueDate

123 1/1/2014 1/1/2014

124 2/1/2014 10/1/2014

125 2/1/2014 1/1/2014

I can easily select say all Orderdate = 2/1/2014

But what I want to select (without using script or an expression) is

Orders where OrderDate>DueDate

I appreciate your help as I've tried to do this in the past but have not been able to (so have used an expression or script)

Re: Selection Across Fields (not in expression or script)

Fri, 11 Apr 2014 07:13:39 GMT

So u can try writing expression in Order number selection box like

if(OrderDate>DueDate,Order Number)

So it will only display order numbers where OrderDate>DueDate

Re: Selection Across Fields (not in expression or script)

MK_QSL — Fri, 11 Apr 2014 07:18:20 GMT

Considering that OrderDate and DueDate both are in different tables and they are connected via Order Number... like below

ORDER:

Load * Inline

[

Order Number, Order date

123, 1/1/2014

124, 2/1/2014

125, 2/1/2014

];

DUE:

Load * Inline

[

Order Number,DueDate

123, 1/1/2014

124, 10/1/2014

125, 1/1/2014

];

You can create a straight table

Dimension = Calculated Dimension

=Aggr(IF([Order date]>=DueDate,'Yes','No'),[Order Number]) //Change >= according to your need

Expression

COUNT(Distinct [Order Number])

Hope this helps..

Re: Selection Across Fields (not in expression or script)

robert99 — Fri, 11 Apr 2014 09:50:39 GMT

Thanks

I can do thsi in a expression dimension or script. but I was hoping I could do it from a selection (so it then appeared in the current selection box and would apply to all chart and tables etc

Re: Selection Across Fields (not in expression or script)

MK_QSL — Fri, 11 Apr 2014 09:54:22 GMT

You can share your sample data or sample apps !

Will try to help you out.

Re: Selection Across Fields (not in expression or script)

robert99 — Fri, 11 Apr 2014 12:05:48 GMT

Yes. But I don't think it can be done

It can be done in script or an expression (or dimensions) not not as a one off easy selection

So it has just taken me an hour+ (to set up in script) whereas I was hoping it was a minute job. Say to type in OrderDate>DueDate

Re: Selection Across Fields (not in expression or script)

jonathandienst — Fri, 11 Apr 2014 12:22:46 GMT

It can't be done in the way you are attempting. Selections are done for the whole set, whereas the expression in the chart is evaluated in the context of the dimension values - so the expression works in the chart but you can't filter it as a selection.

The correct way to do this has already been suggested. Create a flag field in the load like this when loading the orders:

LOAD

....

If(OrderDate > DueDate, 1, 0) As [OrderDate>DueDate],

...

Now select the field [OrderDate>DueDate] to select the overdue orders.

HTH

Jonathan

Re: Selection Across Fields (not in expression or script)

robert99 — Fri, 11 Apr 2014 12:32:17 GMT

Thanks

Im surprised (and a little disappointed) that this can not be done. Everything else I have tried can be but I guess there are other ways to do this

But I have now set this option up in script. It was the better option compared to setting up in the expressions

Re: Selection Across Fields (not in expression or script)

robert99 — Wed, 01 Oct 2014 13:20:10 GMT

Thanks

This was the way I did this. I tried to avoid script but sometimes it has to eb done in script