topic Re: Sete anlysis is not recognisiing the month year syntax in QlikView

OR function for null

smilingjohn — Tue, 12 Jan 2021 12:03:58 GMT

Hi All,

I have a really weired output from the set anaylysis, I need ti display those ID's which ibcludes null values from either one of the column . The below condition works fine when there is value in Case ID and or INcodent ID but this ives wrong total when there is values in the both the fields . it just adds them .

It shows correct ID's but doubles the total when there is values in both the fields (CASE_ID and INCIDENT_ID)

How can I fix this ?

Expression :

=
count({<Department{'HR','Sports'},Type={'Indoor'},CASE_ID-={'null'}>}ID)
+
count({<Department{'HR','Sports'},Type={'Indoor'},INCIDENT_ID-={'null'}>}ID)

Thanks

in Advance

Re: Sete anlysis is not recognisiing the month year syntax

rubenmarin — Tue, 12 Jan 2021 11:14:59 GMT

Hi @smilingjohn, try creating a numeric value for year month like Year(Date) & Num(Month(Date), '00') as CreatedMonthYearNum, using this field it should work.

Also doubles quotes may be used when using comparisons: Count({<Dep={'Sales'} CreatedMonthYearNum={">201711"}>}ID)

Re: Sete anlysis is not recognisiing the month year syntax

smilingjohn — Tue, 12 Jan 2021 11:19:53 GMT

Hi Ruben ,

Sorry By the time I changed my post U have replied to th previous one , which I have done the way u suggested .

Thanks For it .

Can you please look into the latest post of mine which I holding me

Re: Sete anlysis is not recognisiing the month year syntax

rubenmarin — Tue, 12 Jan 2021 11:32:19 GMT

Hi again, you can create the OR in set analysis as:

count(<Department{'HR','Sports'},Type={'Indoor'},CASE_ID-={'null'}>+<Department{'HR','Sports'},Type={'Indoor'},INCIDENT_ID-={'null'}>} JIRA_KEY_ID)

Re: Sete anlysis is not recognisiing the month year syntax

rubenmarin — Tue, 12 Jan 2021 11:38:13 GMT

Now that I see it... there are 2 different fields you want to count? can't it be summarized using only one field?

Re: Sete anlysis is not recognisiing the month year syntax

smilingjohn — Tue, 12 Jan 2021 12:26:04 GMT

@rubenmarin Thanks a lot sir it worked 😀

And i renamed it as One field