topic Re: set analysis fieldvalue in certain time range in QlikView

set analysis fieldvalue in certain time range

Tue, 02 Oct 2012 09:31:28 GMT

Hello,

I am struggling using the set analysis in order to count only fieldvalues that fall into a specified time range. Two variables are used Test_Start and Test_End. They define the time range.

The following formula does not work. The time range will be ignored:

count( {< datereported = {">=$(Test_Start)"}, datereported = {"<=$(Test_End)"}>} ID)

Using only one variable works just fine:

count( {< datereported = {">=$(Test_Start)"} >} ID)

Can anybody give me a hint why the combination of Start and End does not work?

Thanks for your help!

Re: set analysis fieldvalue in certain time range

swuehl — Tue, 02 Oct 2012 09:35:29 GMT

The combination should work, like

count( {< datereported = {">=$(Test_Start)<=$(Test_End)"}>} ID)

Re: set analysis fieldvalue in certain time range

Miguel_Angel_Baeyens — Tue, 02 Oct 2012 09:35:32 GMT

Hi,

Feel free to download this application that shows among many other things how this works. You need to ensure that the format is the same in the variables as well as in the fields. Then, you have to take care of your set analysis syntax.

Hope that helps.

Miguel

Re: set analysis fieldvalue in certain time range

Tue, 02 Oct 2012 09:44:49 GMT

Perfect, thank you!