topic Re: Variable with set analysis in script in QlikView

Variable with set analysis in script

felcar2013 — Tue, 05 Mar 2013 10:41:02 GMT

i have this formula in a chart expression and as i have many of them, i want to create all of them in the script, but i got some problems. The script runs well but i do not get the data in my chart. See please below,

thanks

Expression in Chart

num (count({$<$(vSet), member_Communication_Print_possible={'Yes'}>} Total <$(vTotal)> distinct %x_membermember_ID),'#.##0','.')

Variable in script:

SET TotalPrintMail = 'num(count({@<(=@(vSet)), member_Communication_Print_possible={'Yes'}>} Total <(=@(vTotal))> distinct %x_membermember_ID),'#.##0','.')';

LET TotalPrintMail = Replace(TotalPrintMail,'@','$');

Re: Variable with set analysis in script

Tue, 05 Mar 2013 12:13:00 GMT

SET TotalPrintMail = num(count({@<(=@(vSet)), member_Communication_Print_possible={'Yes'}>} Total <(=@(vTotal))> distinct %x_membermember_ID),'#.##0','.');

LET TotalPrintMail1 = Replace(TotalPrintMail,'@','$');

Re: Variable with set analysis in script

Tue, 05 Mar 2013 19:18:37 GMT

Do like this:

SET var1= '{$<'&'COUNTRY={"Brazil"}>}';

Re: Variable with set analysis in script

Gysbert_Wassenaar — Tue, 05 Mar 2013 19:33:15 GMT

Don't use quotes around the expression:

SET TotalPrintMail = num (count({$<$(vSet), member_Communication_Print_possible={'Yes'}>} Total <$(vTotal)> distinct %x_membermember_ID),'#.##0','.');

Re: Variable with set analysis in script

felcar2013 — Wed, 06 Mar 2013 17:09:39 GMT

thanks, it seems that was the problem