Straight table filtering

[srikantj]

Hi

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

[Anil_Babu_Samineni]

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

[miskin_m]

Hi

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

[srikantj]

i dont have expression

[srikantj]

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

[Anil_Babu_Samineni]

Expected O/P Please?

[srikantj]

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

[miskin_m]

Hi

Use that variable as a calculated dimension

[stabben23]

Hi,

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

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

[srikantj · Accepted solution]

I created list box for ID

i can search any Id

Thanks for alla your suggestions