Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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');

5 Replies
vishsaggi
Not applicable

Re: Resident, Group By, & Where clause

Try this:

LOAD

          distinct Sequence,

          Count([Sound Flag]) as NumberOfSounds

     Resident Sounds

     Where([Sound Flag]= 'Y')

Group By NumberOfSounds;

vishsaggi
Not applicable

Re: Resident, Group By, & Where clause

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 ]

Not applicable

Re: Resident, Group By, & Where clause

Awesome, this works!

Thanks for the help

Community Manager
Community Manager

Re: Resident, Group By, & Where clause

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
Not applicable

Re: Resident, Group By, & Where clause

LOAD Sequence,

          Count([Sound Flag]) as NumberOfSounds

Resident Sounds

Where [Sound Flag] = 'Y'

Group By Sequence;

hope this helps

regards

Marco