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: 
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