topic Re: Straight table filtering in QlikView

Straight table filtering

srikantj — Thu, 19 Jan 2017 06:56:09 GMT

I have a straight table

Ex: Id name no Expression

1 hi

2 raj

3 ram

100000 suresh

I have i lakh records , i want to see only the row that have id= 500023

I can scroll on the scroll bar but i dont want that , i want to see the row for whatever id i want

Qliksss...........Suggest

Re: Straight table filtering

Anil_Babu_Samineni — Thu, 19 Jan 2017 07:00:05 GMT

You must do like this

Sum({<id={'500023'}>}Sales) //This will give for Sales of particular ID.

Or you may show with your expected o/p

Re: Straight table filtering

miskin_m — Thu, 19 Jan 2017 07:03:09 GMT

You can use variable to pass the selection of id field and use this variable in set analysis of your expression

Re: Straight table filtering

srikantj — Thu, 19 Jan 2017 07:12:40 GMT

i dont have expression

Re: Straight table filtering

srikantj — Thu, 19 Jan 2017 07:13:26 GMT

when i dont have expression......??????????????

Re: Straight table filtering

Anil_Babu_Samineni — Thu, 19 Jan 2017 07:17:59 GMT

Expected O/P Please?

Re: Straight table filtering

srikantj — Thu, 19 Jan 2017 07:23:47 GMT

i want only row

id name

500003 sathish

remaining rows i dont want to see

Again when i want 25000 id

i want only that row

Re: Straight table filtering

miskin_m — Thu, 19 Jan 2017 07:30:56 GMT

Use that variable as a calculated dimension

Re: Straight table filtering

stabben23 — Thu, 19 Jan 2017 07:41:48 GMT

Hi,

then use Expression With set analysis to get what you want.

You cant use straight table without Expression, maybe you use Tablebox?

Re: Straight table filtering

srikantj — Thu, 19 Jan 2017 07:49:01 GMT

I created list box for ID

i can search any Id

Thanks for alla your suggestions