Discussion board where members can learn more about Qlik Sense App Development and Usage.
I ran into another issue:
I was trying to assign a String to a "Let"-variable. However, whatever I try, it always returns the variable with "-quotes instead of ' (I use this variable in a "Where"-statement):
Example (in which $(currentCustomerEMail) is interpreted as a Field-value):
LoadCount(OrderEMail) As "NumberOfOrders"Resident OrderWhere $(currentCustomerEMail)='xyz';
Thanks for your help 😉
View solution in original post
what are you trying to do with that load?
This part of the code is contained within a loop. So I have a number of customers (IDs) and a series of dates (YearMonth) I'm looping through to get the count of orders for each timestamp (YearMonth).
i don't understand Where $(currentCustomerEMail)='xyz';what does it means?what is the logic behind this condition?
I'm looping through a table of all orders, and I only want the ones where the Email address of the order table corresponds to the current customer in my loop.