Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

I want to calculate per day category wise data

Hello All,

Stuck in this way menace thing,

I have a excel in which everyday tickets are getting logged, I have to calculate this tickets on per day basis

ex

Date               Category

01-08-2016      Down Call

01-08-2016      Down Call

01-08-2016      Down Call

01-08-2016      Down Call

02-08-2016      Down Call

02-08-2016      Down Call@

02-08-2016      Down Call

02-08-2016      Down Call

02-08-2016      Down Call


Now I have to Calculate on per day like category=''Down Call' and count on single date ex 01 was 4 then adding this with date 02 i.e.

so total would be 9.

I will be dividing the end result with the total no. of devices I have, So that I can have a percentage score for performance evaluation on daily basis for a whole month

6 Replies
rupamjyotidas
Valued Contributor

Re: I want to calculate per day category wise data

Are you looking to accumulate. I didn't get your question. Maybe a sample can help

but accumulation in Qliksense can be done by rangesum and above()

rangesum( above( sum([Expression1]),0,rowno()))

MVP & Luminary
MVP & Luminary

Re: I want to calculate per day category wise data

Hi,

Try like this

Dimension:Category, Date

Expression: Count(Category)/Count(TOTAL <Category> Category)

Hope this helps you.

Regards,

Jagan.

varshavig12
Valued Contributor

Re: I want to calculate per day category wise data

for the first part:

i.e.

Now I have to Calculate on per day like category=''Down Call' and count on single date ex 01 was 4 then adding this with date 02 i.e.

so total would be 9.



What output are you expecting for the second part ?

singhpooja
Contributor III

Re: I want to calculate per day category wise data

Use Aggr(RangeSum(above(Count(Category),0,RowNo())),Date1) for following result in 4th column.

Date1CategoryCount(Category)Aggr(RangeSum(above(Count(Category),0,RowNo())),Date1)
Total 9 
01-08-2016Down Call44
02-08-2016Down Call59

Thanks,

Not applicable

Re: I want to calculate per day category wise data

it should be come as grand total on a KPI visual per day ticket counts could be 3100 and next day if 5 tickets are resolved than 3095 so it should add like 3100+3095 and so on..

rgvavihs
Valued Contributor

Re: I want to calculate per day category wise data

Are you looking for this

Category SalesDate =Count( SalesDate)
9
Down Call01-08-20164
Down Call02-08-20165