topic Re: Hi Friends in QlikView

Hi Friends

Kohli — Wed, 25 Nov 2020 16:16:04 GMT

I have two fields CustID, CustDetails. I straight table it has millions of records. Please give me a expression, If i enter the CustID, I have to get CustDetails in a inputbox.

Re: Hi Friends

avinashelite — Mon, 20 Feb 2017 10:04:47 GMT

Did not get your requirement !! then you select the CustID then it should display the result with the values in the input box ?

if that is the case >Chart Properties >General > Calculated Condition>getselectedcount(CustID )>0

then create a variable for the CustDetails and then place this

maxstring({<CustID ={"=getfieldselections(CustID,',')"}>}CustDetails )

Re: Hi Friends

Mon, 20 Feb 2017 10:13:42 GMT

Could you please elaborate bit more ..

As per my understanding if u enter custid=1 then chart should show the data for only custid =1 else for all cust Ids

if this is ur requirement then

create a variable vvalue = getfieldselections(custid)

and in ur chart dimension will be

if (getselectedcount(custid)>0,'$(vvalue)',custid)

expression is :

=CustDetails

Re: Hi Friends

awhitfield — Mon, 20 Feb 2017 10:42:16 GMT

Why not just use a search object linked to the custid field?

Re: Hi Friends

Kohli — Tue, 21 Feb 2017 04:02:02 GMT

Yes Manoj,

If i enter CustomerID=1, I need to show only CustDetails=1

Re: Hi Friends

Anil_Babu_Samineni — Tue, 21 Feb 2017 04:13:16 GMT

May be use

If(GetSelectedCount(CustomerID) > 0, Count(CustDetails))

It will give output as If User selects CustomerID >0 (That means Starts from 1) then Count will give depends on Associative to CustDetails from CustomerID.

It you need unique counts of Details then you may use DISTINCT over like below

If(GetSelectedCount(CustomerID) > 0, Count(DISTINCT CustDetails))

Re: Hi Friends

Tue, 21 Feb 2017 04:22:58 GMT

Create One Variable

let say vDel in variable overview.

write this one as dimension in ur chart and ur expression will be count(CustDetails)( as per ur data )

if('$(vDel)'=CustomerID,CustomerID)

if u have string in ur "CustomerID" then maintain single quotes for variable

I tried this, its working fine