topic Re: Logic in QlikView

Logic

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

Hi All,

Please find the atahed QVW file ...

Here i have a chart Monthly Summary and a bar chart of Monthly summary for only Severity 1..

Now in the bar chart i aslo want to show the Oct month with zero value as shown in the Striaght table.

But currently my bar chart is showing only till September..

How can i show Oct month ?

need help on this..

Tahnks in advance

...

techvarun — Wed, 25 Oct 2017 05:55:42 GMT

Try the attached.

I used alternate states here

smilingjohn — Wed, 25 Oct 2017 07:29:49 GMT

Hi varun ,

Exacly this is what i wanted it to display ..

can i fix this thing witought the use of alternate state ..

becasue iam not going to use any filter sleection ...

Thanks a lot..

please do suggest ...

I want it to display the way it is display when u select the Severity 1 ..

but i cannnot use it as a alternate state ...

techvarun — Wed, 25 Oct 2017 08:38:23 GMT

Hi John

Then use the dimension like below

and Expressions like below

sum( {1<Jira_Severity= {'Severity 1'} >}PDOpenCount )
sum( {1<Jira_Severity= {'Severity 1'} >}PDCloseCount )
RangeSum(Above(sum( {1<Jira_Severity= {'Severity 1'} >}PDRunningOpenCount ), 0, RowNo()))

Thanks,

Varun