Using Variable in Dynamic Expression

manpri7078 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a very basic query which I am not able to figure out as to where I am doing wrong

In a chart expression I have following : Count({<[Actual Build End Date] = {"=Sum([Actual Build End Date]) > 0"}>}vActual) and it evaluates correctly as per my expectations. But I want a very dynamic expression.

Where vActual is defined as GetFieldSelections(Actual) and results in value selected from the inline table Actual and one of the selected value is [Actual Build End Date]. It means the value of variable vActual is [Actual Build End Date].

I want to dynamically make expression of count such that it ignores all empty values from the field [Actual Build End Date]. There is one dimension called Week, which is not relevant here. My intention is that for the given week I want count of all rows in the field [Actual Build End Date] which has one or other date ignoring blanks.

Can you all help me by substituting my variable name in the main expression which is red in color. I hope I am clear in my query.

Regards

Manish Prasad

Re: Using Variable in Dynamic Expression

Yousef_Amarneh — Wed, 13 Nov 2019 04:45:50 GMT

As per my understanding, you want to count the "Actual Build End Date" field and ignore the blanks, I think you can use the below in your script when you load the data:

Load ......,

If(IsNull("Actual Build End Date") or "Actual Build End Date"='',0,1) as "Actual Build End Date Counter"

From ........

Then in your expression just use Sum("Actual Build End Date Counter")

topic Using Variable in Dynamic Expression in QlikView

Using Variable in Dynamic Expression

Re: Using Variable in Dynamic Expression