Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
srikantj
Creator
Creator

Straight table filtering

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

1 Solution

Accepted Solutions
srikantj
Creator
Creator
Author

I created list box for ID

i can search any Id

Thanks for alla your suggestions

View solution in original post

9 Replies
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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
miskin_m
Partner - Creator
Partner - Creator

Hi

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

srikantj
Creator
Creator
Author

i dont have expression

srikantj
Creator
Creator
Author

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

Anil_Babu_Samineni

Expected O/P Please?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
srikantj
Creator
Creator
Author

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
Partner - Creator
Partner - Creator

Hi

Use that variable as a calculated dimension

stabben23
Partner - Master
Partner - Master

Hi,

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

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

srikantj
Creator
Creator
Author

I created list box for ID

i can search any Id

Thanks for alla your suggestions