Hello Qlik Experts, I created three buckets (0-7,7-14, and greater than 14) date buckets depending upon my date field and today. In pivot table, I have date as a dimension and date buckets as columns and values as the count of Ticket Numbers.
For the date, i want to see the tickets that are between 0-7 bucket, 7-14 bucket and greater than 14 bucket.
0-7days 7-14 days greater than 14 days
23/05/2023 Count of tickets Count of tickets (last week) Count of tickets (above 14 days)
22/05/2023 Count of tickets Count of tickets (last week) Count of tickets (above 14 days)
21/05/2023 Count of tickets Count of tickets (last week) Count of tickets (above 14 days)
What I am getting is
0-7days 7-14 days greater than 14 days
23/05/2023 Count of tickets - -
22/05/2023 - Count of tickets (last week) -
21/05/2023 - Count of tickets (last week) -
Regards
Hyndavi.S
