topic Re: how can you use multiple functions for a single variable in a set expression? in QlikView

how can you use multiple functions for a single variable in a set expression?

Giansonn — Sat, 16 Nov 2024 18:32:30 GMT

I am running a chart that shows me some time values but I want to exclude items that have not had enough time to be comparable. To do this I fetch a value from the filter in order to limit the dates in the data. Only I want to have multiple expressions for the same variable, how can I do this?

This is what my set expression looks like:

count( {<[date]={"<=$(=date(($(varMaxDate)-v_Max_week_number*7),'DD/MM/YYYY'))"}>} ID)

but I would like to have three expressions for the date variable, potentially using rangemin like this:

=date(=rangemin(=date(($(varMaxDate)-v_Max_week_number*7),'DD/MM/YYYY')),=date(($(varMaxDate)-v_Max_day_number),'DD/MM/YYYY')),=date(($(varMaxDate)-v_Max_sale_number*30.42),'DD/MM/YYYY'))))

This however does not work, how can I formulate this expression to make it work?

Re: how can you use multiple functions for a single variable in a set expression?

vamsee — Thu, 04 Jun 2020 01:56:23 GMT

Try using one more variable, like

vExpression = If(Condition1=TRUE,'=date(=rangemin(=date(($(varMaxDate)-v_Max_week_number*7),'DD/MM/YYYY'))', If(Condition2=TRUE, '=date(($(varMaxDate)-v_Max_day_number),'DD/MM/YYYY')),' If(Condition3=TRUE, '=date(($(varMaxDate)-v_Max_sale_number*30.42),'DD/MM/YYYY'))))', 'Null()' )))

Use this variable in your expression

count( {<date={"$(vExpression)"}>} ID)

While creating the chart the expression might show an error but, would still work.

Re: how can you use multiple functions for a single variable in a set expression?

Giansonn — Thu, 04 Jun 2020 08:21:10 GMT

This is a fantastic idea! However I think I will do it using rangemax of the v_max variables times by their day number in a new variable, I will let you know how it goes!