topic Re: Extra calander dates issue in QlikView

Extra calander dates issue

yadav_anil782 — Mon, 20 Jul 2015 11:08:33 GMT

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

Re: Extra calander dates issue

sunny_talwar — Mon, 20 Jul 2015 11:14:22 GMT

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

Re: Extra calander dates issue

yadav_anil782 — Mon, 20 Jul 2015 11:59:15 GMT

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');

Re: Extra calander dates issue

sunny_talwar — Mon, 20 Jul 2015 12:05:46 GMT

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.

Re: Extra calander dates issue

PrashantSangle — Mon, 20 Jul 2015 12:13:50 GMT

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

Re: Extra calander dates issue

yadav_anil782 — Tue, 21 Jul 2015 09:32:08 GMT

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

Re: Extra calander dates issue

PrashantSangle — Tue, 21 Jul 2015 09:39:18 GMT

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