Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with SET ANALYSIS and input field

Hello all,

I need help for a problem with the set analysis function. I have a table with customer number, a creation date of an invoice and a field with the value of the invoice.

For the users I like to create a input box, where there can input a date. Then I like to have a sum of the invoices from the customer where the creation date is less or equal as the date in the input box.

I have defined a variable in the document (FDatum) and create a input box for this variable. The database field called: OffenePostenHistorie.BELDATUM

The invove value field called: OffenePostenHistorie.OBETRAG

I have used the following set analysis function, but it doesn't work:

sum({$<OffenePostenHistorie.BELDATUM <= {$(FDatum)}>} OffenePostenHistorie.OBETRAG)

The format of the date in the table is YYYYMMDD and I put a date with the same format in the input box.

Can anybody give me a hint whats wrong?

Thanks in advance.

Michael

1 Solution

Accepted Solutions
Not applicable
Author

Hi Try the following

sum({$<OffenePostenHistorie.BELDATUM = {'<=$(FDatum)'}>} OffenePostenHistorie.OBETRAG)

regards

View solution in original post

5 Replies
Not applicable
Author

Hi,

I believe it should be:

sum({$<OffenePostenHistorie.BELDATUM = { "<= {$(FDatum)}">} OffenePostenHistorie.OBETRAG)

Regards,

Jonathan

Not applicable
Author

Hi Jonathan,

thanks for your help, but it doesn't work ....

Not applicable
Author

you have to make sure the date is interpreted as a number. So in you model you should calcuate

OffenePostenHistorie.BELDATUM as number same as for vaiable below.

Create a variable and evalute it as:

vDatum = num(Date#($(FDatum),'YYYYMMDD'))

Then use vDatum in set analyse

Regards,

Jonathan

Just tried it myself again:

Expr :

count({$< TetsDateValue= {">$(vDate)"}>} REQD_Number)

where TetsDateValue is calculated in model as round(Date('f'ieldwithdate') and vDate =

vDatum = num(Date#($(FDatum),'YYYYMMDD'))

Worked for me at least

Not applicable
Author

Hi Try the following

sum({$<OffenePostenHistorie.BELDATUM = {'<=$(FDatum)'}>} OffenePostenHistorie.OBETRAG)

regards

View solution in original post

Not applicable
Author

Hi Nick,

that was the sollution for me! Your set analysis definition works great...

Many, many thanks to you!

Michael