Need help with set expression

wanijkesv — Thu, 23 Feb 2023 16:21:36 GMT

I am new to qliksense and I'm trying out a scenario as part of my learning. I have two tables Sales(contains Sales_Date) and Target(contains Target_Year and Target_Value). Sales table has values for every day and Target has year level data. I'm trying to create a table visual with both data combined. So the table visual will have the following columns: Sales_Date Target_Value

Since the Target table has year level data, I'm trying to bring Target_Value into the table visual using the below set expression in a measure =Sum({<Target_Year = {$(=Year(Date(Sales_Date)))}>}Target_Value)

This doesn't seem to work and I get no value. The expression editor doesn't throw any error. The next option would be to create a Sales_Year column in the Sales table and associate it with the Target_Year in Target table to get the corresponding Target_Value. But I would like to understand why the above expression doesn't work. Do set expression not work in row level? Any guidance is greatly appreciated.

Thank you.

Re: Need help with set expression

sidhiq91 — Thu, 23 Feb 2023 17:08:40 GMT

@wanijkesv There is a minor issue with the set analysis Expression. Also, which Year are you looking at?

Something like below expression should help:

Sum({<Year={"$(=Year(Max(OrderDate)))"}>}LineSalesAmount)

Try to replicate the same expression using your Dimensions.

topic Re: Need help with set expression in QlikView

Need help with set expression

Re: Need help with set expression