topic Re. :Regarding Set analysis at the expression containing GREATER THAN AND LESS THEN Sign in QlikView

Regarding Set analysis at the expression containing GREATER THAN AND LESS THEN Sign

Fri, 20 Aug 2010 10:32:42 GMT

Hi All
This is Dushyant
I need your help in my current project to use set analysis.
I want to use set analysis on this
expression ,i consulted it with Mr. Raj Kishor and he

suggested me to mail you regarding
this set analysis expression.

Scenario-In this expression value is coming correct for
current selection of month without set analysis but i want
value for previous month also on the same selection that
can be possible only using set analysis.
So i want to apply set analysis on this expression which is
giving perfect value without set analysis. Apart from this
for your refrence i am sending that application(qv document)
in that document sanction number is giving perfect value i
want same for both the month (selected and selected-1).
Please help me as this is very urgent.

----------

Expression:

[
COUNT(DISTINCT if(SAL_SE = 'SALARIED' and
((
(Date( LoginSanctionTATDate) -
Date(LoginSancitonTAT_LOGGED_IN_DATE))
) <= 5), SANCTION_APP,

if(SAL_SE = 'SELF EMPLOYED' and
(
((Date(LoginSanctionTATDate) -
Date(LoginSancitonTAT_LOGGED_IN_DATE))
) <= 12), SANCTION_APP
)
))
]

Re. :Regarding Set analysis at the expression containing GREATER THAN AND LESS THEN Sign

martin59 — Fri, 20 Aug 2010 10:46:04 GMT

Hi,

I'm not sure, I didn't try but it should be something like this :

=Count( {<SAL_SE={SALARIED}, LoginSanctionTATDate={"<=$(=(LoginSancitonTAT_LOGGED_IN_DATE+5))"}>+<SAL_SE={'SELF EMPLOYED'}, LoginSanctionTATDate={"<=$(=(LoginSancitonTAT_LOGGED_IN_DATE+12))"}>} Distinct SANCTION_APP)

Re. :Regarding Set analysis at the expression containing GREATER THAN AND LESS THEN Sign

Fri, 20 Aug 2010 10:56:38 GMT

I attached sample application herewith.

i think it's would be solve your problem.

Regards

Ashish

Re. :Regarding Set analysis at the expression containing GREATER THAN AND LESS THEN Sign

Wed, 08 Sep 2010 14:09:56 GMT

This post has 0 verified answers | 0 Replies | 1 Follower

Suggest an Answer

Stop Following Follow this Question ...

Points 17

dushyant.icon posted on 09-08-2010 8:18 AM

Debtor Details.qvw

Hi All
I am facing one problem in set analysis in using (NOT IN) Clause .
I am having cases where i am having file Nos (DebtNo.) those are present in Current month(Suppose-Aug)
and Having File No those are present in Previous month that will be July .
Now i want one result using set anlysis in which i can get cases those were present in July BUT NOT IN August ..
....

or i can take another case like i want cases from august(Current Month) those were absent (Not in) in July .

How can i get this result using set anlysis because i am using current and previous month logic here .
Please find out attached doccuement for your refrence and suggest if you can do the needfull changes in that doccument.

As per my uderstanding we should use (NOT IN) Syntax but i dont know how to use or implement this is set analysis...
Please help me ..........

Please reply me @ dushyant

This post has 0 verified answers | 0 Replies | 1 Follower

Suggest an Answer

Stop Following Follow this Question ...

Points 17

dushyant.icon posted on 09-08-2010 8:18 AM

Debtor Details.qvw

or i can take another case like i want cases from august(Current Month) those were absent (Not in) in July .

As per my uderstanding we should use (NOT IN) Syntax but i dont know how to use or implement this is set analysis...
Please help me ..........

Please reply me @ dushyant