topic How to show top 6 months data in App Development

How to show top 6 months data

Arun_141 — Mon, 20 Dec 2021 21:08:46 GMT

Hi Qlik experts,

I am new to qlik , i have one requirement where i want to show top 6 months data (which includes the months which has no data ). In the below image we can see month is showing all the numbers(1-12), my requirement is to show only latest 6 months(i.e 7-12). I have used the expression if(Sum( {1} Month)>0, sum({<Month={">6"}>}Order),0) but it is still showing months (1-6), which i want to remove. Please help.

I am using below sample data.

Sales:
LOAD * INLINE [
Month Team Order
1 A 4
3 B 5
4 A 2
4 B 7
6 B 5
7 B 3
8 A 10
8 B 4
9 A 12
12 A 6
];

Calender:
LOAD * INLINE [
Month
1
2
3
4
5
6
7
8
9
10
11
12
];

Re: How to show top 6 months data

Lisa_P — Wed, 27 May 2020 23:11:07 GMT

You are overthinking it.

sum({<Month={">6"}>}Order)

Re: How to show top 6 months data

Arun_141 — Thu, 28 May 2020 04:21:28 GMT

if we use the expression sum({<Month={">6"}>}Order), it will show the graph for the month 7-12, but if we make a selection in a field let us suppose in Team field, then it will not show the months which dont have data available for the selected value (image1). My requirement is to show the bar chart for the selected value of a field + 0 values bar for any months from 7 to 12 where there is no data for selected value.