topic Re: find sum of ACount and BCount using SetAnalysis and Variables in QlikView

find sum of ACount and BCount using SetAnalysis and Variables

khasimvali85 — Wed, 04 Jun 2014 15:44:04 GMT

find sum of ACount and BCount using SetAnalysis and Variables

i have Tables like

ComplaintDate ComplaintNo ACount BCount ID

12/03/2014 AGR130320140154 N 1 56342

13/03/2014 DEL150320140155 N 1 56343

14/03/2014 UPR160320140156 N 1 56344

01/04/2014 AND020420140160 N 1 56345

15/04/2014 KER170420140162 Y 1 56347

25/04/2014 PUN260420140163 Y 1 56350

My Requirement is

1, only 'N' Values Count in (Total of ACount)

2, BCount Using Set Analysis and Variables,

3, If i want to select one Date in Calender Table disply Previous 3 days Dates.

Re: find sum of ACount and BCount using SetAnalysis and Variables

swuehl — Wed, 04 Jun 2014 16:17:28 GMT

I am not sure I fully understand your requirements (so it would be helpful if you add your expected outcome to above sample), but here are some possible answers:

=count(if(ACount = 'N', ACount))

=count({<Acount = {'N'}>} ACount)

2) ???

Sorry, don't understand your req.

3) ???

Sorry, don't understand your req. Where do you want to display what data when selecting a date?

Re: find sum of ACount and BCount using SetAnalysis and Variables

khasimvali85 — Wed, 04 Jun 2014 16:47:02 GMT

Hi Swuehl,

Thanks for your Answer

2, B Count is also Same but using Set Analysis and Variables

3, i want to display for example if i select one Date like 04/06/2014 i want to display 3 previous days is 03/06/2014 , 02/06/2014, 01/06/2014 using set analysis and variables

Regards

Khasim.

Re: find sum of ACount and BCount using SetAnalysis and Variables

khasimvali85 — Wed, 04 Jun 2014 17:15:27 GMT

3rd Requirement is i want display like this

01/06/2014 02/06/2014 03/06/2014

Acount Bcount ACount% BCount% ACount BCount ACount% BCount% ACount BCount ACount%BCount%

Regards

Khasim.

Re: find sum of ACount and BCount using SetAnalysis and Variables

Anonymous — Wed, 04 Jun 2014 17:26:22 GMT

Three previous days count would be:

count({1<CompliantDate={"$(='>=' & date($(vDate)) & '<=' & date($(vDate)-2))"}>} WhateverYouCountHere)

where vDate is a variable contining the selected date. If always one date is selected, it is
=CompliantDate
If multiple dates are selcted, you maybe need the earliest one:
=date(min(CompliantDate))
or the latest:
=date(min(CompliantDate))

Re: find sum of ACount and BCount using SetAnalysis and Variables

khasimvali85 — Wed, 04 Jun 2014 17:59:03 GMT

Thanks Michael