Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Display only two values in a bar chart

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


2 Replies
Partner
Partner

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())

Partner
Partner

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