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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
BI_Dev
Creator II
Creator II

Data display in a chart (Bar or Combo)

I have data as below - In the bar chart I want to show the Max of Total Badge-in only as  a dot - 

Measure expression is count(distinct Badge-in)/count(distinct days).How can I show max as a point in the same chart - Here it should show 9,902 on 'TUE' bar.

 

BI_Dev_0-1740412283882.png

 

Labels (3)
2 Solutions

Accepted Solutions
MatheusC
Specialist II
Specialist II

Hi,

Using the match chart, try the approach below with the pick function in conjunction with match:

pick(match(

                count(distinct [Total Badge-in]),

    max(total aggr(count(distinct [Total Badge-in]),[Badge Weekday])))+1,Null(),max(total aggr(count(distinct [Total Badge-in]),[Badge Weekday])))

Adjust according to your data.

- Regards, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

View solution in original post

Chanty4u
MVP
MVP

Try this

If(Count(DISTINCT [Badge-in]) / Count(DISTINCT [Days]) =  

   Max(Aggr(Count(DISTINCT [Badge-in]) / Count(DISTINCT [Days]), [DayOfWeek])),  

   Count(DISTINCT [Badge-in]) / Count(DISTINCT [Days])  

 

)

View solution in original post

3 Replies
Ben_P
Creator II
Creator II

Change your chart to a combo chart, then add a new measure, something like the below, and display as marker:

if(
count(distinct Badge-in) =
max(TOTAL aggr(count(distinct Badge-in),[Weekday])),
count(distinct Badge-in)
)

This is saying, if your measure for any given dimension value is the same as the max value across all dimension values, then display it... so would result in a point for the day with the max value, and nothing for other days.

You may also want to display it on a secondary axis to ensure the bars still have a reasonable height.

MatheusC
Specialist II
Specialist II

Hi,

Using the match chart, try the approach below with the pick function in conjunction with match:

pick(match(

                count(distinct [Total Badge-in]),

    max(total aggr(count(distinct [Total Badge-in]),[Badge Weekday])))+1,Null(),max(total aggr(count(distinct [Total Badge-in]),[Badge Weekday])))

Adjust according to your data.

- Regards, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Chanty4u
MVP
MVP

Try this

If(Count(DISTINCT [Badge-in]) / Count(DISTINCT [Days]) =  

   Max(Aggr(Count(DISTINCT [Badge-in]) / Count(DISTINCT [Days]), [DayOfWeek])),  

   Count(DISTINCT [Badge-in]) / Count(DISTINCT [Days])  

 

)