Mini chart in QlikSense showing incorrect data

Kaushik2020 — Tue, 07 Nov 2023 11:42:09 GMT

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.

topic Mini chart in QlikSense showing incorrect data in App Development

Mini chart in QlikSense showing incorrect data