Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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
Champion III
Champion III

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
Champion III
Champion III

in list box you wil get only distinct values

Chanty4u
Champion III
Champion III

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

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

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

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
Champion III
Champion III

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)