topic Expression in QlikView

Expression

deepakqlikview_123 — Tue, 25 Mar 2014 07:18:49 GMT

Hello All,

Can you please tell me how below exp will work

in title of chart

=GetCurrentSelections('-')&'='&count(distinct if((EnquiryStatusID = '3' or EnquiryStatusID = '4'),EnquiryID))/1000

thanks

Re: Expression

MK_QSL — Tue, 25 Mar 2014 07:21:36 GMT

This will give you result of COUNT of EnquiryID in thousands where EnquiryStatusID is either 3 or 4.

Get Current Selections will give you selected Field Name...

Re: Expression

sushil353 — Tue, 25 Mar 2014 07:23:57 GMT

Hi,

It will Returns a string with the current selections in the document separated by '-' also concatenated with a count of EnquiryID where EnquiryStatusID is either 3 or 4

HTH

Sushil

Re: Expression

its_anandrjs — Tue, 25 Mar 2014 07:30:04 GMT

The below will gives what you select current in list box

=GetCurrentSelections('-')

and below script counts DISTINT UNIQUE EnquiryID where it is equals to EnquiryStatusID = '3' or EnquiryStatusID = '4' and divides to 1000 and get values and concat with =GetCurrentSelections('-') with &'='& and shows value like Value = depends on the EnquiryID value

count(distinct if((EnquiryStatusID = '3' or EnquiryStatusID = '4'),EnquiryID))/1000

Hope this helps