topic Re: Count and charts in QlikView

Count and charts

samuel_brierley — Mon, 02 Sep 2013 12:34:11 GMT

Hi ive asked this before and i dont thinki explained it too well, attached is a small smaple.

Dropbox - qlikview.xlsm https://www.dropbox.com/s/h9mqhmc58yc0l2m/qlikview.xlsm

What im after is a chart that will show at any time how many are unavailable,

thanks

Re: Count and charts

Anonymous — Mon, 02 Sep 2013 16:05:21 GMT

Samuel,

I'm not going to download the files, but can give you an advice - take a close look at set analysis, especially element function E (for Excluded). An example from "help":

sum( {$<Customer = E({1<Product={‘Shoe’}>})>} Sales )
returns the sales for current selection, but only those customers that never bought the product ‘Shoe’. The element function E( ) here returns the list of excluded customers; those that are excluded by the selection ‘Shoe’ in the field Product.

Regards,

Michael

Re: Count and charts

samuel_brierley — Tue, 03 Sep 2013 07:33:48 GMT

I understand not wanting to download anything but that wont work unfortunatly, what the file shows is in each row there is a date/time item went offline and when it came back so what the formula needs to do is show all items where the date/time went offline is greater than date specified and date/time is less than date/time specified.

thanks

Re: Count and charts

Anonymous — Tue, 03 Sep 2013 13:47:23 GMT

Samuel,

From your latest explanation, it looks simpler than I thought. No need for the set analysis (the unavailable term confused me). It is more likely a combination of conditions in if(), e.g.

if(DateTimeWentOffline>$(SelectedTime) and DateTimeCameBack<$(SelectedTime), ...)

Hope it helps. If not, I'll download your file - but only if you upload it right here.

Regards,

Michael