
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Resident, Group By, & Where clause
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');
- Tags:
- qlikview_scripting


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
LOAD
distinct Sequence,
Count([Sound Flag]) as NumberOfSounds
Resident Sounds
Where([Sound Flag]= 'Y')
Group By NumberOfSounds;


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ]

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Awesome, this works!
Thanks for the help

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LOAD Sequence,
Count([Sound Flag]) as NumberOfSounds
Resident Sounds
Where [Sound Flag] = 'Y'
Group By Sequence;
hope this helps
regards
Marco
