Resident, Group By, & Where clause

[#1]

I'm wondering if it is possible to use a resident load with a group by statement and a where clause. There is either a syntax error or perhaps this is not possible. Thanks for the help in advance!

TempTable:

     LOAD

          distinct Sequence,

          Count([Sound Flag]) as NumberOfSounds

     Resident Sounds Group By NumberOfSounds

     Where([Sound Flag]= 'Y');

[vishsaggi]

Try this:

LOAD

          distinct Sequence,

          Count([Sound Flag]) as NumberOfSounds

     Resident Sounds

     Where([Sound Flag]= 'Y')

Group By NumberOfSounds;

[vishsaggi]

Reference Guide Load Statement Syntax:

load [ distinct ] *fieldlist

[( from file [ format-spec ] |

from_field fieldassource [format-spec]

inline data [ format-spec ] |

resident table-label |

autogenerate size )]

[ where criterion | while criterion ]

[ group_by groupbyfieldlist ]

[order_by orderbyfieldlist ]

[#4]

Awesome, this works!

Thanks for the help

[Anonymous]

Hi Seth,

We're glad to see you got a solution. Please take a moment to Mark Replies as Correct and Helpful to give points to members who helped you and to mark the thread as Answered.

Thank you,

Qlik Community Team

[MarcoWedel]

LOAD Sequence,
          Count([Sound Flag]) as NumberOfSounds
Resident Sounds
Where [Sound Flag] = 'Y'
Group By Sequence;

hope this helps

regards

Marco