topic Expressions in QlikView

Expressions

deepakqlikview_123 — Wed, 19 Mar 2014 06:25:20 GMT

Hello expert,

Can you please tell me how below expression will work.

1 dual

(count(distinct EnquiryID)/1000 & ' (' & num((count(distinct EnquiryID)/count(distinct total EnquiryID)), '0.00%') & ')', count(distinct EnquiryID)

2 count

(distinct{$<Year= {$(=Max(Year))}>} EnquiryID)
-
count(distinct{$<Year= {$(=Max(Year)-1)}>} EnquiryID)
)
/
count(distinct{$<Year= {$(=Max(Year)-1)}>} EnquiryID)
)

dual

(count(distinct if( EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID))/1000 &
' (' & num((count(distinct if(EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID))/
count(distinct total if(EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID))), '0.00%') & ')',
count(distinct if(EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID))
)

Thanks,

Re: Expressions

deepakqlikview_123 — Thu, 20 Mar 2014 05:55:10 GMT

Hello All,

Can you please help me out in this.

Thanks

Re: Expressions

er_mohit — Thu, 20 Mar 2014 06:12:43 GMT

Hii in first

1 dual

(count(distinct EnquiryID)/1000 & ' (' & num((count(distinct EnquiryID)/count(distinct total EnquiryID)), '0.00%') & ')', count(distinct EnquiryID)

here you Calculate the unique EnquiryID with % utilization of unique EnquiryID using this expression as above ' (' & num((count(distinct EnquiryID)/count(distinct total EnquiryID)), '0.00%') & ')' and last one is only used for sorting purpose as alike your EnquiryID because from starting you using dual function

in 2nd case

2 count(distinct{$<Year= {$(=Max(Year))}>} EnquiryID) //for getting the EnquiryID on based of maximum year
- count(distinct{$<Year= {$(=Max(Year)-1)}>} EnquiryID))/ //or getting the EnquiryID on based of maximum year -1like if its 2014 then it display 2013
count(distinct{$<Year= {$(=Max(Year)-1)}>} EnquiryID) //or getting the EnquiryID on based of maximum year -1 and divide it to above two ) expression output

3rd case

dual

here first getting unique the EnquiryID with condition EnquiryStatusID <> '0' and FinanceTypeID=2 and also % utilization for each EnquiryID as alike 1st case but here it done with using conditions and last expression count(distinct if(EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID)) is used to display the above expression with sorting purpose

because of using dual function