topic Re: filter data current year in App Development

filter data current year

Ayden — Tue, 26 Oct 2021 01:27:27 GMT

hello fellow Qlik developers, please i have few questions.

1. how do i write an expression that would filter my Data table with information for current year. I have a field with dates which I converted to year like so YEAR(Field).

2. I want to create Two variables that i can use with the variable input chart at the front end

( questions how do i create those variables at the script level that shows sum(Qty) and the other is the multiplication of fields Unit*Qty. want to be able to use the variable input to toggle my application.

Thanks in Advance

Re: filter data current year

AshutoshBhumkar — Tue, 26 Oct 2021 03:41:19 GMT

Hello,

1. You can write the expression like Sum({<Year = {"$(=Max(Year))"}>}) to get sales for Current/Max Year.

2. To create variables in Script and store Qty value and Unit*Qty, you need to make calculations in the table and use Peek function to get and store that specific value in the variable.

Thanks,

Ashutosh

Re: filter data current year

Ayden — Tue, 26 Oct 2021 06:14:32 GMT

thanks for your response, how can i use peek to achieve this. could you please show me an example.

thanks

Re: filter data current year

AshutoshBhumkar — Tue, 26 Oct 2021 07:29:43 GMT

Check this example.

Table:
load * inline [
Date, Week, ID, Sales
9/1/2021, 1, A, 10
9/1/2021, 1, B, 20
9/7/2021, 2, A, 32
9/7/2021, 2, C, 31
9/14/2021, 3, A, 20
9/15/2021, 3, B, 25
9/16/2021, 3, D, 20
9/20/2021, 4, A, 20
9/20/2021, 4, D, 25
9/21/2021, 4, B, 10
9/27/2021, 5, A, 20
9/27/2021, 5, F, 25
9/28/2021, 5, D, 20
10/4/2021, 6, A, 25
10/5/2021, 6, B, 11
10/6/2021, 6, C, 12
10/11/2021, 7, A, 10
10/11/2021, 7, C, 25
];

SalesTable:
Load Sum(Sales) as TotalSales
Resident Table;

Let vSalesVariable = Peek('TotalSales',0,'SalesTable');

Exit Script;

Thanks,

Ashutosh

Re: filter data current year

Ayden — Tue, 26 Oct 2021 14:49:46 GMT

thanks it work now i get this below any idea how to fix it.

Re: filter data current year

AshutoshBhumkar — Tue, 26 Oct 2021 15:04:07 GMT

Hello,

Variables created in script and frontend will hold only one value.

You can writes simple Sum(Sales) in the variables.

What exactly is the requirement ?