topic Get a count from values between a certain range in QlikView

Get a count from values between a certain range

Tue, 02 Aug 2016 11:17:39 GMT

Dear all,

I have the following data that I would like to load

LOAD * INLINE [
DATE, WEEKIN
2012-02-02, 2
2012-02-02, 3
2012-02-02, 4
2012-02-04, 4
2012-02-06, 6
];

And I have set the following variables:

set vDate1 = "2012-02-02";
set vDate2 = "2012-02-04";

I would like to create a graph that shows the count of the values between date1 and date2. So therefore I created a graph with the following expression

count(<DATE={'>=$(vDate1) <=$vDate2)'}>}[WEEKIN]

But this gives me an error. Any thoughts on where I go wrong?

Re: Get a count from values between a certain range

Anil_Babu_Samineni — Tue, 02 Aug 2016 11:25:39 GMT

Perhaps this?

count({<DATE = {'>=$(vDate1) <=$(vDate2)'}>}[WEEKIN])

Attached

Re: Get a count from values between a certain range

sunny_talwar — Tue, 02 Aug 2016 11:30:42 GMT

What error are you getting?

Re: Get a count from values between a certain range

Tue, 02 Aug 2016 11:33:00 GMT

Hi Anil,

Thanks. For your reply. I am getting a graph now but the count seems to be wrong... I get a count of 5 now. While only 4 values fit the criteria.... Any thoughts?

Re: Get a count from values between a certain range

Anil_Babu_Samineni — Tue, 02 Aug 2016 11:34:53 GMT

Yes, Because your data has 3 times for vdate1. If you want to show values of Count, you can use Values on Data Points

Re: Get a count from values between a certain range

vinieme12 — Tue, 02 Aug 2016 11:38:22 GMT

Can you give a screenshot of what you are looking at or your own sample qvw? the expression above by Anil should give you the correct result.

Re: Get a count from values between a certain range

Tue, 02 Aug 2016 11:46:47 GMT

I already solved it! Thanks for your input guys!