topic Help with ValueList in QlikView

Help with ValueList

Wed, 25 Nov 2020 16:16:04 GMT

Hello Everyone,

I need to built a report in the format below:

Conditions:

1. On selection of a particular Year, count of orders delivered for the Year should be populated Quarter wise and Count of orders at the end of the Year should also be populated.

I have written two expressions which counts orders delivered and orders pending respectively based on Value List.

But for "Order not yet delivered", data for previous quarters are also getting populated ( which is actually the count of orders delivered)which is not required.

Please help to get the report in the correct format.

Thanks in advance,

Jemimah

Re: Help with ValueList

MindaugasBacius — Mon, 11 Jul 2016 08:05:39 GMT

Could you please share with a sample of data?

Re: Help with ValueList

sushil353 — Mon, 11 Jul 2016 08:05:58 GMT

Hi,

Can you share sample application?

Re: Help with ValueList

marcus_sommer — Mon, 11 Jul 2016 08:13:12 GMT

I don't understand why there are (yellow) subtotals Q1-Q4 within the column Delivery Date then the quarter will be displayed as a horizontal dimension.

Beside them I would try to solve the case within the script by creating a datamodel which the Order (delivered + not delivered), Regions and Quarter associate and the simply use as expression: count(Order) and not synthetic dimensions with valuelist.

- Marcus