Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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