topic Display only two values in a bar chart in QlikView

Display only two values in a bar chart

djallelsadki — Thu, 16 Jun 2011 13:45:01 GMT

Hello,

if somebody can help me

I want to display the first value and the last in a graph,

as shown in the following histogram

Thank you for your help

Djallel SADKI

stigchel — Thu, 16 Jun 2011 13:53:35 GMT

I think you can check in your expression whether the dimension is Min or Max and otherwise results in Null?

If(Dim=Min(Dim) or Dim=Max(Dim), expression, null())

djallelsadki — Thu, 16 Jun 2011 14:06:15 GMT

it only shows the value of the selected month

the expression is:

=Sum({$ <Année= {$(=Only(Année))},Mois={"<=$(vThisMonth)"}>}[1.4])

/Sum({$ <Année= {$(=Only(Année))},Mois={"<=$(vThisMonth)"}>}[1.3])

The dimension is the Month

Thank you for your help