Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I face some issue on while using set analysis.
I have loaded the data
LOAD
DateSK,
Date(Date#(DateSK,'YYYYMMDD'),'MM/DD/YYYY') as ActiveDate,
LOMAddsSK,
CountriesSK,
CustomerTypeSK,
GenderSK,
LanguageSK,
RankSK,
ItemCateogrySK,
CustomerCategorySK,
AgeGroupSK,
LOMSignupSK,
If(Paid = 'Yes', 1, 0) as [Active Paid],
CustomerStatusSK
//IsTestCustomer
FROM
[C:\Users\smamo\Documents\QlikViewDB\QVDs\DemographicDashboardQVDs\FactDailyActiveCustomers.qvd]
(qvd)
Where Year(Date(Date#(DateSK,'YYYYMMDD'),'MM/DD/YYYY')) >= Year(Today())-1;
Then I put the maximum value in a variable
LET vMaxActiveDate = 'Max(ActiveDate)';
Then when I used it in set analysis as a filtering condition
=num(sum({<ActiveDate={'$(vMaxActiveDate)'}>}ActiveCount), '#,##0')
It results 0 but when I put a hard coded date instead of the variable it displays like
=num(sum( {< ActiveDate={"06/30/2019"}>}ActiveCount), '#,##0')
It gives me a result
I also checked my variable value in another check box by giving a value = $(vMaxActiveDate) and it gives me the maximum date
Can anyone help me what did I do wrong?
try this:
LET vMaxActiveDate = '=Max(ActiveDate)';
Did Frank's post resolve the issue? If so, please give him credit by clicking the Accept as Solution button on his post, and if it did not help, either provide further information, or let everyone know what you did to fix things, and after you post that, you can mark that as the solution as well.
Regards,
Brett