topic Re: Script in QlikView

Script

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

HI All

Please find the attachment of the qvw and the excel sheet ...

Can please anyone sugest me how do i achieve this ?

1.need to plot a bar chart

Report should display only data of selected month and prior 11 months prior to the current month

For example

On selection of Dec 2014 , report should display from Jan 2014 to Dec 2014

Total = (Total from last month (if not there consider 0) + Open based on the Status for current month) -Closed based on the Status for the current month

Example :

For Jan 2015

Total for Dec 2014 = -247

Opening for Jan 2015 = 17

Closing for Jan 2015 = 36

Total for Jan2015 = (Total for Dec 2014 + Opening for Jan 2015) - Closing for Jan 2015

i.e. (-247 + 17) -36

Thanks in advance

Re: Script

Anil_Babu_Samineni — Thu, 13 Jul 2017 07:15:53 GMT

You missed attaching, Will you?

Re: Script

smilingjohn — Thu, 13 Jul 2017 07:28:36 GMT

Hi Anil

I have attached them please check ....

Thanks

Re: Script

Anil_Babu_Samineni — Thu, 13 Jul 2017 07:48:09 GMT

Look here? Change accordingly as you require the data points

I change script for your MonthYear field like

Date(Date#(MonthYear, 'MMM-YYYY'),'MMM-YYYY') as MonthYear

I used this expression in straight object

Count({<MonthYear = {">=$(=Date(YearStart(MonthYear),'MMM-YYYY')) <=$(=Max(MonthYear))"}>}Open)