topic Set Analysis Ignore Selection and stilldo partial set in QlikView

Set Analysis Ignore Selection and stilldo partial set

Fri, 12 Mar 2010 16:32:20 GMT

Hey,

I'm looking for a way to ignore the selections made by a user and then still do some set analysis.

I Know that with {1} you can ignore the users selection, but then i would still like to use a expression like

SUM({<[ZZSYS_COUC_YWEEK]={"$(Dash_SelWeek)"} >} [Tickets]).

In the manual you can do a 1- of 0+ but ... can't get it coded.

Set Analysis Ignore Selection and stilldo partial set

Fri, 12 Mar 2010 16:51:03 GMT

Hello,

I am using {1} to ignore all selections and then set selections in the set-analysis for single fields, like

SUM({1<Month='1'>} Value}

Depending on the number of fields, the other way is more practical (I use that more often), i.e. to ignore the selection of single fields:

SUM({<Month=>} Value)

hth,
Thilo

Set Analysis Ignore Selection and stilldo partial set

Fri, 01 Apr 2011 11:46:25 GMT

I do not want to open an own thread for my question,

I would need the "ignore selection" function but NOT within a sum function, I would like to combine it with max date

something like

=max({1} Invoicedate)

With this function i want to inform the user until which date the data is reported in Qlikview, and this information should not change if you select year 2010 (then max(INvoicedate) becomes 31.12.2010)

Hope anyone has an idea,

thanks in advance,

christoph

Set Analysis Ignore Selection and stilldo partial set

Fri, 01 Apr 2011 11:57:39 GMT

Hi Christoph,

so far I see your expression works as you expect.

Are you sure that you used 1 instead of $?

Rainer

Set Analysis Ignore Selection and stilldo partial set

Fri, 01 Apr 2011 12:25:17 GMT

Thank you for the fast reply Rainer,

Additionally I added the date-function,

-> =max({1} date(Invoicedate))

but unforunately it isnt working, when i select 2010 the textbox with the formula above it shows 31.12.2010 =(

Set Analysis Ignore Selection and stilldo partial set

Fri, 01 Apr 2011 12:49:23 GMT

Christoph,

which version of QlikView you are working with?

Next idea (Script):

- Sort your table where INVOICEDATE is located in: Order By INVOICEDATE

- Create a variable LET vInvoiceDate = Peek('INVOICEDATE', -1, 'INVOICEDATETABLE');

OR:

MaxDate:
Load
Max(InvoiceDate) as MaxInvoiceDate
Resident INVOICEDATETABLE,

LET vInvoiceDate = Peek('MaxInvoiceDate', -1, 'MaxDate');

Good luck!

Rainer

Set Analysis Ignore Selection and stilldo partial set

Mon, 04 Apr 2011 09:23:16 GMT

Rainer, thank you again for your prompt reply and good ideas

I am using QV9 but all i need to to was this step:

MaxDate:
Load
Max(InvoiceDate) as MaxInvoiceDate
Resident INVOICEDATETABLE,

the strange thing is that i'm sure that i have tried that before 😃

sooo thanks a lot!!!