topic Re: Need help Counter Funtion in QlikView

Need help Counter Funtion

NavinReddy — Tue, 04 Jun 2013 17:58:12 GMT

Hi All,

Could some help me this Query

By using counter function How should i display like it

if im wrong corrent me how should i disply like the way

Thanks & Regards

Niranjan

Gysbert_Wassenaar — Tue, 04 Jun 2013 18:19:33 GMT

See attached qvw

edit:

// The script to load some example data

Input:

LOAD *, if(not isnum(F2), SubField(F2,',')) as F3 INLINE [

F1, F2

p , "p1,p2,p3,p1,p1"

q , "q1,q2,q3,q2,q2"

r , "r1,r2,r3,r1,r1"

s , 10101

];

Add a straight table with F1 as dimension and as expression FirstSortedValue(F3, -aggr(count(F3),F3))

NavinReddy — Wed, 05 Jun 2013 00:54:17 GMT

Hi Gysbert,

im using persional edition so i can't able to open will you plz copy and paste it here

Thanks & Regards

Niranjan

Sokkorn — Wed, 05 Jun 2013 02:24:52 GMT

Hi Niranjan,

Try this

1. Load data

[Data]:

LOAD * INLINE [

Field1, Field2

p , "p1,p2,p3,p1,p1"

q , "q1,q2,q3,q2,q2"

r , "r1,r2,r3,r1,r1"

s , 10101];

2. Create Straight table

a. Dimension: Field1

b. Expression: If(IsNum(Field2),Null(),SubField(Field2,',',1))

Regards,

Sokkorn