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: 
Kaushik2020
Creator III
Creator III

Mini chart in QlikSense showing incorrect data

Hi All,

I am creating a Mini chart using Bar to show ticket raised trend for the past 6 months. 

This month the count is more than the Previous month. But if you see the mini chart, there is no such indication as part of bar chart representation. 

If I use Sparkline this tells me that the count of ticket is reduced. 

Diff column shows - Difference between MTD and LMTD.

Green color tells which month being highest.
Red color indicates which month being the lowest.

Expression to show trend: 

count({$<Year=, Month=, Day=,
DateKey={">=$(=Floor(Monthstart(Max(DateKey),-5)))"}>}
distinct Txt_IssueID)

 

For MTD:

count({$<Year=, Month=, Day=,
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
distinct Txt_IssueID)

 

For LMTD: 

count({$<Year=, Month=, Day=,
Date={">=$(=date(monthstart(max(Date),-1)))<=$(=date(addmonths(max(Date),-1)))"}>}
distinct Txt_IssueID)

 

Please suggest. 

Labels (1)
0 Replies