topic Re: Set analysis Greater than and less than in QlikView

Set analysis Greater than and less than

Wed, 25 Nov 2020 16:16:04 GMT

I am strugling with set-analysis of greater than and less than with numerical Feilds. Below is the expression expression for exmaple: Actually i have to compare kd_time with von and bis. Here kd_time, von, bis fields are numeric

date, kd_date fields are in date format

=if(Count({<[LP.date]={'=LP.kd_date'}, [LP.kd_time]={'>=$[LP.von]<=$[LP.bis]'},LP.kd_date={'*'}-{''}>}VK.ln), 'T','X')

i am able to acheive this with IF condition but i want to do this with set analysis

count ( if([LP.date]=(LP.kd_date) and LP.kd_time >= LP.von and LP.kd_time <= LP.bis and LP.kd_date<>0,VK.ln))

Thanks in advance!

Regards,

Re: Set analysis Greater than and less than

sunny_talwar — Wed, 09 Nov 2016 12:25:13 GMT

May be this:

=Count({<[LP.date] = P(LP.kd_date), [LP.kd_time] = {"=[LP.kd_time] >= $[LP.von] and [LP.kd_time] <=$[LP.bis]"}, LP.kd_date={'*'}-{''}>} VK.ln)

Re: Set analysis Greater than and less than

hemanthaanichet — Wed, 09 Nov 2016 12:51:10 GMT

Below is the expression i think

Count({<[LP.date] = {=$[LP.kd_date]}, [LP.kd_time] = {"=[LP.kd_time] >= $[LP.von] and [LP.kd_time]<=$[LP.bis]"}, LP.kd_date={'*'}-{''}>} VK.ln)

Regads

Hemanth

Re: Set analysis Greater than and less than

Wed, 09 Nov 2016 12:55:15 GMT

Thanks Sunny,

The whole syntax all together is not working

but below mentioned part is working correctly:

=if(Count({<[LP.date] = P(LP.kd_date), LP.kd_date={'*'}-{''}>} VK.ln),'t','x')

but below mentioned, when we are comparing greater than less than this is not working:

=if(count({<[LP.kd_time] = {"=[LP.kd_time] >= $[LP.von] and [LP.kd_time] <=$[LP.bis]"}>}Vk.ln),'t','x')

thanks for your quick answer!

Re: Set analysis Greater than and less than

sunny_talwar — Wed, 09 Nov 2016 14:09:35 GMT

My bad, can you check without the dollar sign. I think I missed it by mistake

=Count({<[LP.date] = P(LP.kd_date), [LP.kd_time] = {"=[LP.kd_time] >= $[LP.von] and [LP.kd_time]<= $[LP.bis]"}, LP.kd_date={'*'}-{''}>} VK.ln)

So try this:

=Count({<[LP.date] = P(LP.kd_date), [LP.kd_time] = {"=[LP.kd_time] >= [LP.von] and [LP.kd_time] <= [LP.bis]"}, LP.kd_date={'*'}-{''}>} VK.ln)

Re: Set analysis Greater than and less than

Wed, 09 Nov 2016 15:12:44 GMT

Many Thanks Sunny,

its work 99% but just 4-5 records are not correct.:) so right now i don't know whats the problem. may be you know?

Regards,

Sneh

Re: Set analysis Greater than and less than

sunny_talwar — Wed, 09 Nov 2016 15:59:12 GMT

Is this coming from a single table? Do you have a unique identifier in that table?

Re: Set analysis Greater than and less than

Fri, 11 Nov 2016 08:40:18 GMT

Hello Sunny,

no, it's not coming from single table. and i have no unique identifier.

have a nice day from Germany!

Thanks,

Sneh

Re: Set analysis Greater than and less than

sunny_talwar — Fri, 11 Nov 2016 10:26:02 GMT

In that case you might be better off using if statement rather then using the set analysis.