topic How to filter in expression when variable is used for dates? in QlikView

How to filter in expression when variable is used for dates?

turtle_qlikview — Sat, 16 Nov 2024 17:38:54 GMT

I am using Variable to select dates in my expression on straight table. sum($(vSETYTD) Sales). How can I apply filter to select a particular customer?

The below expression doesn't give me any results.

sum({<$(vSETYTD), Customer=-{'123','345'}>} Sales)

Re: How to filter in expression when variable is used for dates?

mfchmielowski — Tue, 05 Jan 2021 16:10:27 GMT

First thing is the value of the variable. Can You provide information about it ?

When you create an expression in straight table dont put label on in. You'll be able to see how the expression looks like. Will be good if you paste full expanded expression here.

Re: How to filter in expression when variable is used for dates?

turtle_qlikview — Tue, 05 Jan 2021 17:03:01 GMT

Variable vSETYTD is as below. Copied from variable overview :

{$<Year={$(=max(total Year))}, MonthDayNo={"<=$(=max(total MonthDayNo))"},Month=,[Month Year]=,Quarter=,Date=,Week=,WeekNo=>}

My current Expression is sum($(vSETYTD) Sales), to which I want to apply customer filter.

Re: How to filter in expression when variable is used for dates?

mfchmielowski — Tue, 05 Jan 2021 17:28:21 GMT

With this SetExpression selecting customers in listbox will work.
Do i understand correctly: You want to add customer ids to this set dynamicaly ?

Re: How to filter in expression when variable is used for dates?

turtle_qlikview — Tue, 05 Jan 2021 18:18:18 GMT

This is what I did and it worked:

I expanded the variable and added the customer label to it.

My Final Expression:

sum({$<Year={$(=max(total Year))}, MonthDayNo={"<=$(=max(total MonthDayNo))"},[Customer]={'123','345'},Month=,[Month Year]=,Quarter=,Date=,Week=,WeekNo=>}Sales)