Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
djallelsadki
Partner - Creator
Partner - Creator

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
stigchel
Partner - Master
Partner - Master

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
Partner - Creator
Partner - Creator
Author

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