Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vignesh_s
Creator
Creator

load inline

i loaded the following value,but when i list it ,im geting only one 9 insted of 2 9's

LOAD * INLINE [

    ID

    10

    9

    9

    8

    7

    6

];

vi.png

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

load this and  create a table box in  front end

LOAD * INLINE [

    ID,pro

    10,a

    9,b

    9,c

    8,c

    7,d

    6,e

];

View solution in original post

9 Replies
Chanty4u
MVP
MVP

in list box you wil get only distinct values

Chanty4u
MVP
MVP

load this and  create a table box in  front end

LOAD * INLINE [

    ID,pro

    10,a

    9,b

    9,c

    8,c

    7,d

    6,e

];

vignesh_s
Creator
Creator
Author

even in pivot table or stright table im nt geting,i usend rank function as expressionvi.png

sunny_talwar

Because one again, you only have one dimension (ID) and unless you add another one which essentially repeats the ID, it will only be shown once. You can add another expression as Count(ID) and you will see that ID 9 will have a count of 2

Anil_Babu_Samineni

May be work around

Capture.JPG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anil_Babu_Samineni

Instead, Generate to call RecNo() as ID

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Chanty4u
MVP
MVP

yes anil,

but just wanted to show him with other dimension

vignesh_s
Creator
Creator
Author

i have 2 9's so im geting 2-3 and 2-3 for 8 i got 4 ,so i should get 3 as rank for 8,can i get the expression for tat

v.png

sunny_talwar

Try see if you can understand from this thread

Continuous Ranking (no missing Rank)