topic Resident, Group By, & Where clause in QlikView

Resident, Group By, & Where clause

Mon, 08 Aug 2016 15:04:38 GMT

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

Re: Resident, Group By, & Where clause

vishsaggi — Mon, 08 Aug 2016 15:44:31 GMT

Try this:

LOAD

distinct Sequence,

Count([Sound Flag]) as NumberOfSounds

Resident Sounds

Where([Sound Flag]= 'Y')

Group By NumberOfSounds;

Re: Resident, Group By, & Where clause

vishsaggi — Mon, 08 Aug 2016 15:47:06 GMT

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 ]

Re: Resident, Group By, & Where clause

Mon, 08 Aug 2016 15:51:35 GMT

Awesome, this works!

Thanks for the help

Re: Resident, Group By, & Where clause

Anonymous — Mon, 08 Aug 2016 16:12:57 GMT

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

Re: Resident, Group By, & Where clause

MarcoWedel — Tue, 09 Aug 2016 23:32:42 GMT

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

hope this helps

regards

Marco