topic Re: Need help on count in QlikView

Need help on count

Fri, 16 Mar 2012 12:28:54 GMT

Hi,

Thank you for all past solutions!

Now on attached qvw file, i have got two question (see on file) which i am struggling to display a chart.

Can someone please help me out here?

Thanks,

Dinesh

Re: Need help on count

swuehl — Fri, 16 Mar 2012 12:38:38 GMT

Maybe like attached?

Create two straight table charts, with Title as dimension,

then as expression in first chart

=count({<[Create Date] = {">=$(=today()-90)"}>}[Create Date])

and in second

=if(sum({<[Create Date] = {">=$(=today()-90)"}>} Subscriber)<=50,

sum({<[Create Date] = {">=$(=today()-90)"}>} Subscriber),0)

Re: Need help on count

Fri, 16 Mar 2012 12:56:05 GMT

Thanks swuehl for quick replied.

But the result is not correct. If you take a look the revised data (attached)

Q1: Ans: B,F,J,L,M,O,R,S

Need help on count

swuehl — Fri, 16 Mar 2012 13:02:46 GMT

I've read the 'no create date' as number create date, maybe mislead by the need help on count 😉

Try just

=count({<[Create Date] = {"<$(=today()-90)"}>}[Create Date])

Re: Need help on count

swuehl — Fri, 16 Mar 2012 14:11:46 GMT

If you could have multiple create date per Title, above expression will get an incorrect result if you have some create dates before and some after the 90 days threshold, but I think this one could handle it:

=count({<Title = e({<[Create Date] = {">=$(=today()-90)"}>}) >} Title)

Re: Need help on count

Fri, 16 Mar 2012 14:18:14 GMT

thanks swuehl,

Shall i apply same logic for other Question that needs to display less than 50 subscribers in the last 90 days?

Re: Need help on count

swuehl — Fri, 16 Mar 2012 14:31:52 GMT

The current logic should be fine if I understood your question correctly, here we filter the create dates and we are not interested in events that took place before, right?

Re: Need help on count

Fri, 16 Mar 2012 14:40:04 GMT

Thanks swuehl for all solutions.

i think we need to limit only last 90 days timeframe regardless if any event took place before. So do we need to approch differently?

Need help on count

swuehl — Fri, 16 Mar 2012 14:58:36 GMT

Well, I think you should be fine with what you have now (see my last attachment).

You'll need to test if the results are ok, maybe I still do misunderstand your requirements.

Regards,

Stefan

P.S. It's a good habit to mark answers as helpful or correct and to close the thread by marking answers as correct or by changing the OP status to 'assumed answered', as soon as you have resolved your issue.

Not only for this discussion, but for all the discussion you opened. This rewards the effort of the fellow discussion members and helps other to quickly grasp the relevant parts of a discussion.