Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Experts,
i'm adding three table and creating master calander with the "RELEASE_DATE" from Release table but once i'm fatching data ,i'm getting extra dates agained table ,
plz revert if any one can resolve this issue
Hi,
try below,
count({<RELEASE_FLAG={'Y'},Relese_APPROVAL_STATUS={'APPROVED'},BOOKING_STATUS-={'1','2','4','10'},APPROVAL_STATUS-={'APPROVED','INPROGRESS'}>}Unit_id)
you can also use e() instead of -=
Note: -= gives you red line but it will work correctly
Regards
Those extra dates are created by your master calendar and since you are seeing everything in the table box object you see all dates that your master calendar creates. If you don't want to see it in the table box object you can go on the presentation tab and select the 'Omit Null when field is NULL' option for a field from your fact table and you won't see the extra dates
If you don't want those dates in the application, don't create a master calendar.
HTH
Best,
Sunny
thanks for rply
i wants to calculate count of "Unit_id" in sat analysis -
with this condision-
from reslease table- where (RELEASE_FLAG='Y' and APPROVAL_STATUS='APPROVED');
and from booking header- Where not Match(BOOKING_STATUS, 1, 2, 4,10) and not Match(APPROVAL_STATUS, 'APPROVED', 'INPROGRESS');
Are you aiming to do this in the script? or on the front end? Where clauses are used only in the script and Set Analysis is a front end thing. Not sure what exactly you are looking for.
Hi,
try below,
count({<RELEASE_FLAG={'Y'},Relese_APPROVAL_STATUS={'APPROVED'},BOOKING_STATUS-={'1','2','4','10'},APPROVAL_STATUS-={'APPROVED','INPROGRESS'}>}Unit_id)
you can also use e() instead of -=
Note: -= gives you red line but it will work correctly
Regards
Hello,
-= and () is working fine but i'm not able to understood the use of this, why we are not using only "="
note- this question is only for gain qlik knollege
Hi,
Yes you can use = only if you know which value you have to take.
In your earlier question you said you want from booking header- Where not Match(BOOKING_STATUS, 1, 2, 4,10) and not Match(APPROVAL_STATUS, 'APPROVED', 'INPROGRESS') because of it I am using -=(not equal)
Regards