topic Re: Set analysis in QlikView

Set analysis

Tue, 28 May 2013 16:21:43 GMT

I have 15 events that each contains a startdate and enddate.

In my set analysis, I'm trying to count the number of occurrences where the first event (1) occurs but event 12,13,14 and 15 does not.

Also, I want to measure the time from event 1 starts to event 12 ends, but if there is no event 12 the latest enddate from event 2 to 11 should be chosen.

Thanks.

Re: Set analysis

jolivares — Tue, 28 May 2013 21:50:36 GMT

Try to post an example ... is better to understand what really you want.

Re: Set analysis

Tue, 28 May 2013 22:45:48 GMT

We need to see your data model to reply your question ....

Re: Set analysis

Wed, 29 May 2013 07:07:36 GMT

Sorry about that.

So here is example of the data. I want to add a few columns to my pivot table.

An expression where I count the cases where event 1 exists but 12,13 and 14 doesn't (which should be Case A and E)

And secondly an expression where I measure the time from event 1 starts (startdate) to event 12 ends (enddate). (Only case C has both event 1 and 12)

But if event 12 doesn't exist, the time from event 1 starts to any of event 2-11 (enddate) should be measured. Only case E should be measured, according to the data.

Hope that helps.

Thanks.

Re: Set analysis

Thu, 30 May 2013 11:17:01 GMT

Anyone?

Re: Set analysis

jolivares — Thu, 30 May 2013 20:50:09 GMT

It's not clear what you want in the qvw that already you sent... explain better.

Re: Set analysis

Fri, 31 May 2013 09:14:22 GMT

I uploaded the wrong document, so the correct one is in my previous post.

Re: Set analysis

Gysbert_Wassenaar — Fri, 31 May 2013 13:33:56 GMT

See attached qvw

Re: Set analysis

Fri, 31 May 2013 21:17:39 GMT

Here you may find good set analysis guide:

http://community.qlik.com/docs/DOC-1867

From my experiences: the most important thing in qlikview app is data model. It is here much more important, than in any other kind of system. Good data model will do a lot of work for you, making your formulas less complicated. Sometimes it is worth to calculate something during data load, to have easier callculations at run time. I very often calculate some flags to have easy way to check some conditions....

Regards

Darek