Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SETANALYSIS on formula based on variable

Hello,

I'm trying to search the expression to make a setanalysis with variable.

Something like this :

=sum(

    {$<

        [aDate] = {"makedate(year(vDate),month(vDate),day(vDate))"}

    sales

)

please,

thank you.

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Did you tried like this?

sum(

    {$<

        [aDate] = {"$(=makedate(year(vDate),month(vDate),day(vDate)))"}

    sales

)

View solution in original post

2 Replies
Not applicable
Author

Hi,

Did you tried like this?

sum(

    {$<

        [aDate] = {"$(=makedate(year(vDate),month(vDate),day(vDate)))"}

    sales

)

Not applicable
Author

Perfect, it works, thank you.