Set Analysis Ignore Selection and stilldo partial set

[#1]

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.

[#2 · Accepted solution]

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

[#3]

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

[#4]

Hi Christoph,

so far I see your expression works as you expect.

Are you sure that you used 1 instead of $?

Rainer

[#5]

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 =(

[#6]

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

[#7]

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!!!