topic Re: Group by - invalid expression error fix! in QlikView

Group by - invalid expression error fix!

bushpalaamarnat — Wed, 25 Nov 2020 16:16:04 GMT

Here is my table:

Brand_Analysis:

NoConcatenate

LOAD

Area,

Year,

Month,

[Year/Month],

[Rx vs CH 2],

[Supply Chain],

Region,

Market,

[Market 2],

[Category 1],

[Category 2],

[Category 3],

[Therapeutic Area],

[Global Brand],

[Raw Materials],

WIP,

API,

[FG (inc. Other)],

Provisions,

[Net Inventory],

[Memo: Strategic Inventory],

[Net Inventory less Strategic],

[Brand Category],

[Site Category],

[Site Flow Location],

[Brand (DIO)],

[Product Group],

[Global Planning Therapy],

Brand_Site,

Franchise,

sum(if([Site Flow Location]='Primary', [Raw Materials])) AS [Primary RawMaterials]

Resident Brand_Analysis1

group by Area, Year, Month,[Year/Month],[Rx vs CH 2];

Drop Table Brand_Analysis1;

I am getting invalid expression error.

What i am trying to do is calculate primary raw material .

The point is

in chart, i have created sum function to calculate Primary Raw Materials and second raw materiel . however unable to produce or select data to filter for only primary raw material.

Re: Group by - invalid expression error fix!

marcus_sommer — Thu, 18 Jan 2018 10:56:38 GMT

You need to include all fields within the group by which aren't aggregated not only a few ones.

- Marcus

Re: Group by - invalid expression error fix!

bushpalaamarnat — Thu, 18 Jan 2018 11:10:36 GMT

Thank you Marcus... it worked. and was correct answer.

This thread does not show me option to select correct answer. is there a way to do that when it does not give option "correct answer".

Re: Group by - invalid expression error fix!

marcus_sommer — Thu, 18 Jan 2018 11:14:04 GMT

It's a limitation from the inbox that the correct button is missing and that no attachments are visible or that the advanced editor isn't available - just opening this thread within a new tab and it will work.

- Marcus