topic Re: Input Box doubt in QlikView

Input Box doubt

Mon, 11 Mar 2013 12:06:25 GMT

Hai Community Members,

Is their anyway to give value of a in input box and select that records in straight table of pivot table of charts. Thanks in advance

Regards,

ramesh

Re: Input Box doubt

kaushiknsolanki — Mon, 11 Mar 2013 12:09:54 GMT

Hi Ramesh,

You can do this.

Consider this example. Say you have Employee_ID which user will be entering into variable say vEmployee.

Then only thing you need to do is in chart expression.

sum({<Employee_ID = {"$(vEmployee)"}Sales)

Hope this is clear.

Regards,

Kaushik Solanki

Re: Input Box doubt

Mon, 11 Mar 2013 13:21:07 GMT

Hai Koushik,

Thanks for your response, I have done in the way you said, but unable to get the selected the date can you correct me.I have attached the sample. Please correct me

regards,

ramesh

Re: Input Box doubt

sarahallen1 — Mon, 11 Mar 2013 15:38:48 GMT

Remove your dimension =(vsid). Remove your expression count(vsid).

Add a new expression:

only({$<SID={$(='s0'&vsid)}>}SID)

Re: Input Box doubt

Mon, 11 Mar 2013 15:42:54 GMT

Thanks Sarahallen , It is working amazing...

Regards

Ramesh