topic Re: Expression in QlikView

Expression

deepakqlikview_123 — Mon, 17 Mar 2014 10:12:45 GMT

Hello Team,

Can you please tell me how below expression works,

='Locationwise Enquiry Analysis ( In K)' &

chr(10)&chr(13) &

GetcurrentSelections('-')&'='& Count (distinct EnquiryID)/1000

Thanks in advance.

Re: Expression

MK_QSL — Mon, 17 Mar 2014 10:26:56 GMT

='Locationwise Enquiry Analysis ( In K)' & ==> This will type as it is

chr(10)&chr(13) & ==> NEW LINE

GetcurrentSelections('-')& ==> Give you your current selection

'=' ==> give you =

& Count (distinct EnquiryID)/1000 ==> Your DISTINCT EnquiryID Count will be divided by 1000

SO your result would be something like below

Locationwise Enquiry Analysis ( In K)

Customer Name: ABCD =0.001

Considering that your have selected Customer ABCD from Customer Name Field... Hope this helps...

Re: Expression

CELAMBARASAN — Mon, 17 Mar 2014 10:27:56 GMT

Hi,

& is concatenate two strings

Chr(10) is Line Feed

Chr(13) is Carriage return

GetcurrentSelections will give you the selected values with field names.

Count (distinct EnquiryID)/1000 will give you the number of enquiries in (K).

Re: Expression

Luis_Cortizo — Mon, 17 Mar 2014 10:28:43 GMT

It writes the text: 'Locationwise Enquiry Analysis ( In K)', and then in a new line (that's the reason to concatenate chr(10) and chr(13) t shows the current selections of the document separated by the '-' sign before and equal sign and after that the distinct number of values of the fields EnquiryID divided by 1000

So, let's say that you have selected 2014, January and the distinct number of values on the field EnquiryID is 150000; your expression would return:

Locationwise Enquiry Analysis ( In K)

Year: 2014 - Month: Jan = 150

Hope it helps.

Best regards.

Re: Expression

Mon, 17 Mar 2014 10:38:06 GMT

it will show the text 'Locationwise Enquiry Analysis ( In K)', the current field that you have selected(fieldname and the data) and it will do the calculation at the end, something like this:

Locationwise Enquiry Analysis ( In K) Fieldname: datainfield = Count (distinct EnquiryID)/1000