topic Re: load inline in QlikView

load inline

vignesh_s — Wed, 25 Nov 2020 16:16:04 GMT

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

LOAD * INLINE [

];

Re: load inline

Chanty4u — Wed, 20 Dec 2017 14:28:17 GMT

in list box you wil get only distinct values

Re: load inline

Chanty4u — Wed, 20 Dec 2017 14:30:00 GMT

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

];

Re: load inline

vignesh_s — Wed, 20 Dec 2017 14:34:14 GMT

even in pivot table or stright table im nt geting,i usend rank function as expression

Re: load inline

sunny_talwar — Wed, 20 Dec 2017 14:41:27 GMT

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

Re: load inline

Anil_Babu_Samineni — Wed, 20 Dec 2017 14:44:03 GMT

May be work around

Re: load inline

Anil_Babu_Samineni — Wed, 20 Dec 2017 14:47:02 GMT

Instead, Generate to call RecNo() as ID

Re: load inline

Chanty4u — Wed, 20 Dec 2017 14:48:22 GMT

yes anil,

but just wanted to show him with other dimension

Re: load inline

vignesh_s — Thu, 21 Dec 2017 07:13:04 GMT

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

Re: load inline

sunny_talwar — Thu, 21 Dec 2017 12:23:41 GMT

Try see if you can understand from this thread

Continuous Ranking (no missing Rank)