Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am working on creating measure where variable is already created but now i want to restrict that data based on Yesterday's data and Current month data
Variable: $(vOverall_Inquiry_Count) where we are just doing sum(inquiry_number), we cannot change logic in variable hence i am try to apply set analysis outside variable on Qlik Saas.
Tried some thing like below but not sure if this is the correct way.
{<[Received_Date.autoCalendar.Date]={"$(=Date(Today()-20, 'MM/DD/YYYY'))"}>} $(vOverall_Inquiry_Count)
Please help
From a syntax perspective, that looks like it should work correctly. I'm not sure why you've chosen today()-20 as your cutoff - that's not "Yesterday and current month" - but that's not related to the use of variables and set analysis.
If you're using Qlik Sense, you'll probably want to use a Master Measure for your formula, rather than a variable, but a variable will also work.
@Or I tried creating master measure as well, but it not working