topic Re: How to use rangecount in qlikview? in QlikView

How to use rangecount in qlikview?

chinnu123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

Can any one give me example on how to count previous month data..

For example If I am having Tickets of current months along with previous month I need to show the percentage of that so how to write expression for that. If I am not wrong I need to use range count

Here I am having Tickets and Target tickets Here when I am select current month the data should accumulate with previous month and to show percentage for that

Here month field is dimension and if I select Service it should take count from june to september and to show % of that field

I.e Target tickets/Total tickets of that field.

Hope I am clear I am attaching sample data for better understanding

Re: How to use rangecount in qlikview?

Anil_Babu_Samineni — Fri, 21 Oct 2016 02:13:41 GMT

What are you expecting, Would you please share expected result from same excel and then update new one

Re: How to use rangecount in qlikview?

harishkumarg — Fri, 21 Oct 2016 04:04:07 GMT

Are you expecting something like this -

A straight table with Month as dimension where each month will show the below values,

June - Count (June's Target Tickets) / Count (June's Tickets)

July - Count (June and July's Target Tickets) / Count (June and July's Tickets)

Aug - Count (June+July+Aug's Target Tickets) / Count (June+July+Aug's Tickets)

Sep - Count (June+July+Aug+Sep's Target Tickets) / Count (June+July+Aug+Sep's Tickets)

Plus you need a filter for Group and if you select a Group value say 'Service' then you need to see values related to Service alone?

Please confirm or correct this!

Regards

Harish

Re: How to use rangecount in qlikview?

chinnu123 — Fri, 21 Oct 2016 07:16:16 GMT

Yes Harish. I am expecting the same need to show in bar chart.

Re: How to use rangecount in qlikview?

jyothish8807 — Fri, 21 Oct 2016 08:19:34 GMT

Hi Chinnu,

Hope this what yo u are looking for:

Regards

Re: How to use rangecount in qlikview?

jyothish8807 — Fri, 21 Oct 2016 08:20:36 GMT

From Presentation Tab hide Exp1 and Exp2.

Regards

Re: How to use rangecount in qlikview?

harishkumarg — Fri, 21 Oct 2016 12:55:44 GMT

Please find the attached.

Hope this helps!

Regards

Harish

Re: How to use rangecount in qlikview?

harishkumarg — Sat, 22 Oct 2016 04:20:08 GMT

Did this work?

Regards

Harish

Re: How to use rangecount in qlikview?

chinnu123 — Tue, 25 Oct 2016 17:42:36 GMT

Hi Harish,

Thanks for your help it's working fine But one question when we click on the individual bars it showing different percentages Because Why I am asking is Users will click on the individual bars and they will check the related data on back end So can you please advise on this...

Re: How to use rangecount in qlikview?

johnw — Tue, 25 Oct 2016 18:22:39 GMT

Modified example to add an As Of table. Clicking on the bars keeps the same percentage now, and all related data is selected.

AsOf:

LOAD date(fieldvalue('Month',recno())) as [Month]

AUTOGENERATE fieldvaluecount('Month')

;

LEFT JOIN (AsOf)

LOAD [Month] as [As Of Month]

RESIDENT AsOf

;

INNER JOIN (AsOf)

LOAD *

RESIDENT AsOf

WHERE [As Of Month] >= [Month]

;

Dimension = As Of Month

Expression = count([Targetmet Tickets])/count([Tickets])

Re: How to use rangecount in qlikview?

harishkumarg — Sat, 29 Oct 2016 09:08:09 GMT

Can you make the object read only?

Regards

Harish

Re: How to use rangecount in qlikview?

chinnu123 — Wed, 02 Nov 2016 13:54:38 GMT

Hi John,

Perfect it's working fine now Thanks for your time...

Regards,

Chinnu.