Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

set analysis fieldvalue in certain time range

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!

1 Solution

Accepted Solutions
MVP
MVP

Re: set analysis fieldvalue in certain time range

The combination should work, like

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


3 Replies
MVP
MVP

Re: set analysis fieldvalue in certain time range

The combination should work, like

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


Re: set analysis fieldvalue in certain time range

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

Not applicable

Re: set analysis fieldvalue in certain time range

Perfect, thank you!