topic Re: Set analysis in QlikView

Set analysis

Mon, 03 Mar 2014 11:47:38 GMT

Hi all , need help , i have a set analysis like this:

=count({$<Date={ ">=$(=Date((Today()-30), 'YYYY.MM.DD')) <=$(=Date((Today()-0), 'YYYY.MM.DD'))" },OfferingCategory1={Narystės}>} DISTINCT SabID)

and i need to iplement If statment into set analysis, like this : {$<Abonement.End={ ">=$(=Date((Today()-60), 'YYYY.MM.DD')) <=$(=Date((Today()-30), 'YYYY.MM.DD'))" }>}

the logic is:

if {$<Abonement.End={ ">=$(=Date((Today()-60), 'YYYY.MM.DD')) <=$(=Date((Today()-30), 'YYYY.MM.DD'))" }>}

then

count({$<Date={ ">=$(=Date((Today()-30), 'YYYY.MM.DD')) <=$(=Date((Today()-0), 'YYYY.MM.DD'))" },OfferingCategory1={Narystės}>} DISTINCT SabID)

please help

Re: Set analysis

nilesh_gangurde — Mon, 03 Mar 2014 11:52:51 GMT

Hi,

you can include the if expression in your count.

For example. you can use the below mentioned expression.

count({$< Abonement.End={ ">=$(=Date((Today()-60), 'YYYY.MM.DD')) <=$(=Date((Today()-30), 'YYYY.MM.DD'))" }

,Date={ ">=$(=Date((Today()-30), 'YYYY.MM.DD')) <=$(=Date((Today()-0), 'YYYY.MM.DD'))" },OfferingCategory1={Narystės}>} DISTINCT SabID)

-Nilesh

Re: Set analysis

Mon, 03 Mar 2014 11:54:34 GMT

im not quite sure what your question is or what you want but try this:

if({$<Abonement.End={ ">=$(=Date((Today()-60), 'YYYY.MM.DD')) <=$(=Date((Today()-30), 'YYYY.MM.DD'))" }>},if({$<Date={ ">=$(=Date((Today()-30), 'YYYY.MM.DD')) <=$(=Date((Today()-0), 'YYYY.MM.DD'))" },OfferingCategory1={Narystės}>}, count(DISTINCT SabID)))

Re: Set analysis

Mon, 03 Mar 2014 12:05:51 GMT

i need count all records where:

{$<Abonement.End={ ">=$(=Date((Today()-60), 'YYYY.MM.DD')) <=$(=Date((Today()-30), 'YYYY.MM.DD'))" }>}

in this set analysis :count({$<Date={ ">=$(=Date((Today()-30), 'YYYY.MM.DD')) <=$(=Date((Today()-0), 'YYYY.MM.DD'))" },OfferingCategory1={Narystės}>} DISTINCT SabID)

Nilesh, yours solution is working, but returns only 2 records, there must be more...

Re: Set analysis

er_mohit — Mon, 03 Mar 2014 12:17:14 GMT

try this

if(num(Abonement.End)>=num(Date((Today()-60)) and num(Abonement.End)<= num(Date(Today()-30)),

count({< Date={ ">=$(=Date((Today()-30), 'YYYY.MM.DD')) <=$(=Date((Today()), 'YYYY.MM.DD'))" }

,OfferingCategory1={Narystės}>} DISTINCT SabID)