topic Re: number in QlikView

number

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

I have chart A and chart B ...

IN chart a i have clicked on any of the number then it will show me all the months and makes other zero and displays the numbers for that row only

as shown in the chart 1 ..

now i want to replresent this like chart B ..

but here the values are shwing in negative becuase i have taken out PDPeriodMonth from expression..

how do i achieve the chart B with same values and there should not be any negative values.....

Please find the attachment of the QVW file

Thanks in advance

Re: number

avinashelite — Thu, 26 Oct 2017 07:06:04 GMT

I am confused what your trying to do in the chart 2 which is very much similar to the chart 1 ...could you please explain what your trying to achieve

Re: number

Anil_Babu_Samineni — Thu, 26 Oct 2017 07:07:52 GMT

That, Means you are going to use Chart-A as excluded from current filter of field and Chart-B need to update with same recent and associate values.. Can you make Chart-B as {1} or Just do "Suppress When value is Null" from presentation tab

Edit - And you need to check the check box like dimension as "Show All values" and Suppress should be checked.

Re: number

smilingjohn — Thu, 26 Oct 2017 08:54:50 GMT

HI Anil ,

This is not working when i use the below expression

RangeSum(Above(Sum({<PDReportPeriodB=>}PDRunningOpenCount), 0, RowNo()))

even after i supress the null values in presentation tab

Re: number

Anil_Babu_Samineni — Thu, 26 Oct 2017 08:58:34 GMT

You can remove that and use now as it is, Here you need to em-pose as my edit option.. Are you expecting like below?

RangeSum(Above(Sum(PDRunningOpenCount), 0, RowNo()))

Re: number

smilingjohn — Thu, 26 Oct 2017 09:54:50 GMT

Hi Anil ,,

I will be using one chart only not two..

I will be using always Chart A only

and will select any number from the any of the severity..

then it should show me only that row..

and the Open Expression will be RangeSum(Above(Sum({<PDReportPeriodB=>}PDRunningOpenCount), 0, RowNo()))

becuase this will always calculte the runing total ..

Thanks

Re: number

sunny_talwar — Thu, 26 Oct 2017 11:44:17 GMT

May be you forgot to check 'Suppress Zero Values' on the presentation tab for Chart A?

Re: number

smilingjohn — Thu, 26 Oct 2017 12:37:05 GMT

Hi Sunny

thanks for the reply

yes this is what i want but I chart B i will be using the below expression for OPEN

RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo()))

For

which your suggested of suppressing value is not working..

Becuase the above expression will give me the perfect runing total

Re: number

sunny_talwar — Thu, 26 Oct 2017 12:39:24 GMT

What is the number you are looking to get in chart B? Also, I thought you just wanted one chart? or do you need both charts with different outputs? What are those outputs?

Re: number

smilingjohn — Thu, 26 Oct 2017 13:15:21 GMT

Hi Sunny ,

I want one chart only ...

Please find the attachment of the QVW file ...

here i have one Table ..

Now i will be selecting any one row from any of the Seveirty then it show me only that slection ..

as shown in the screenshot

I dont want to change my Current expression for OPEN..

I hope iam clear to some extent ..

Need your help

Thanks in advance

Re: number

sunny_talwar — Thu, 26 Oct 2017 13:22:14 GMT

You have used this for OPEN

RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo()))

and you are saying you don't want to use this?

RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo())) * Avg (1)

The output you want is (when Sept 2016 is selected) only one row with 28 for open and you don't want to see all the other rows? Is that correct? Why do you not want to multiply by Avg(1)? What is the problem there?

Re: number

smilingjohn — Thu, 26 Oct 2017 13:29:43 GMT

Hi Sunny ,

If i do so then i will not see the runing total (OPEN)

for example if you clear everything ,,And look at Feb-2016 the created is 0 and CLosed is also 0

but the Open is 20.. and this is how i want ..

Now if i will use *(avg) 1 then this will not show me the Oepn count when created and Closed are 0 ..

Thats the reason i prefer using this expression

RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo()))

Re: number

sunny_talwar — Thu, 26 Oct 2017 13:53:37 GMT

Then it seems to be a problem of missing data and you need to look at this

Generating Missing Data In QlikView