topic Re: Basic Set Analysis in QlikView

Basic Set Analysis

dberkesacn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

pls help me in this simple set analysis, =sum({<Date={">2017.02.01"}>}Value), why this is not working?

Would like to filter the date - global date format in the begging of the script is SET DateFormat='YYYY.MM.DD';.

Thanks,

Re: Basic Set Analysis

prma7799 — Thu, 22 Jun 2017 10:08:17 GMT

Please check date format

=sum({<Date={">01.03.2017"}>}Sales_Total )

This is working in my app.

Re: Basic Set Analysis

MK_QSL — Thu, 22 Jun 2017 10:11:51 GMT

What is the format of your Date field?

Re: Basic Set Analysis

Thu, 22 Jun 2017 10:17:10 GMT

try to use date format of your "Date" data field in set comparision.

Re: Basic Set Analysis

Frank_Hartmann — Thu, 22 Jun 2017 10:29:48 GMT

what format has your "Date" field?

maybe:

sum({<Date={'>2017.02.01'}>}Value)

hope this helps

Re: Basic Set Analysis

dberkesacn — Thu, 22 Jun 2017 11:27:48 GMT

it come from the initial global variable SET DateFormat='YYYY.MM.DD'; and the source data has also this structure.

Re: Basic Set Analysis

prma7799 — Thu, 22 Jun 2017 11:31:35 GMT

Could you please share some sample app

Re: Basic Set Analysis

sasikanth — Thu, 22 Jun 2017 11:36:11 GMT

Try this

=SUM({<Date={"> $(=num(Dat#( '2017.02.01','YYYY.02.01'))) "}>}Value)

Re: Basic Set Analysis

dberkesacn — Thu, 22 Jun 2017 11:46:32 GMT

Yes.

Re: Basic Set Analysis

Frank_Hartmann — Thu, 22 Jun 2017 11:54:11 GMT

see attached file

hope this helps

Re: Basic Set Analysis

prma7799 — Thu, 22 Jun 2017 11:59:19 GMT

It is working with =sum({<Date={"2017.03.01"}>}Value )

Confused

Re: Basic Set Analysis

oscar_ortiz — Thu, 22 Jun 2017 12:23:04 GMT

Check this out. I've modified the script slightly to ensure that your date is using the proper format. Preceding load on your original inline load statement.

LOAD

Date(Date#(Date,'YYYY.MM.DD')) as CheckDate

;

Good luck

Oscar

Re: Basic Set Analysis

prma7799 — Thu, 22 Jun 2017 12:26:10 GMT

Hi Frank,

Without any modification in back end how can we do this?

Thanks

Re: Basic Set Analysis

dberkesacn — Thu, 22 Jun 2017 12:29:52 GMT

Yep it work with '=' but not with '>'... you have the same result ?

Re: Basic Set Analysis

oscar_ortiz — Thu, 22 Jun 2017 12:31:47 GMT

The reason it works with "=" and not ">" is because Qlik is treating the field as a text field not numeric value.

Re: Basic Set Analysis

prma7799 — Thu, 22 Jun 2017 12:34:46 GMT

Yes... But if you change you date format in backend you can easily achieve the same.

Re: Basic Set Analysis

dberkesacn — Thu, 22 Jun 2017 12:35:00 GMT

amazing it was a bug (features?), i just added a preceding load * just this, and worked, after deleted the preceding and reloaded again worked ...

Re: Basic Set Analysis

prma7799 — Thu, 22 Jun 2017 12:36:10 GMT

Re: Basic Set Analysis

dberkesacn — Thu, 22 Jun 2017 12:42:01 GMT

probably it was because I made the data in excel and copy pasted to the inline wizard ... or just because...

Re: Basic Set Analysis

prma7799 — Thu, 22 Jun 2017 12:45:17 GMT

Yes...

Otherwise you will get your answer early..

Thanks Daniel .