My sql query to qlikview script

[balasundaram]

My SQL Query: select A,B,count(1) from bala;

i written in qlikview like

Load A,B,count(1) from bala.qvd;

is it correct ?

any function there in qlikview for my sql COUNT function

[jagan]

Hi,

You will definitely get one, since your table has all unique values

bala:

LOAD * INLINE [

    sno, name

    1, a

    2, b

    3, c

    4, d

    5, e

];

If you have data like this

Temp:

LOAD * INLINE [

    sno, name

    1, a -- duplicate record

    1, a -- duplicate record

    1, c

    2, d

    2, e

];

Data:

LOAD sno,name,count(sno) AS Count

Resident TempGroup by sno,name;

drop table Temp;

Now you will get

sno, name, count

1, a, 2  -- since you have duplicate rows you will get count 2.

1, c, 1

2, d, 1

2, e, 1

Bala, before practicing Qlikview first learn the SQL queries then designing the Datamodel in Qlikview becomes very easy.  Without knowing SQL it is very difficult for a Qlikview developer.

Hope this helps you.

Regards,

Jagan.