variables in set analysis

sirkyQ — Wed, 10 Jul 2019 15:12:15 GMT

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?

Re: variables in set analysis

Frank_Hartmann — Wed, 10 Jul 2019 15:31:48 GMT

try this:

LET vMaxActiveDate = '=Max(ActiveDate)';

Re: variables in set analysis

Brett_Bleess — Thu, 01 Aug 2019 12:25:05 GMT

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

topic variables in set analysis in QlikView

variables in set analysis

Re: variables in set analysis

Re: variables in set analysis