Logic

[smilingjohn]

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]

Try the attached.

I used alternate states here

what is alternate states in Qlikview ?

[smilingjohn]

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 · Accepted solution]

Hi John

Then use the dimension like below

and Expressions like below

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

Thanks,

Varun