topic Re: Where condition is not working in Cubes in QlikView

Where condition is not working in Cubes

Mon, 26 Jan 2026 21:26:37 GMT

Hi All,

I used where condition in following script but it is not working. it showing full data only. i do not know whether i am making any mistake in the condition. the data fetched from Cubes via SAPOlapconnector.

[$0SD_C03]:

Load *;

Select PseudoMDX D (

Dimensions (

[0CALYEAR] (),

[0FISCPER] ()),

From ($0SD_C03))

where [0CALYEAR] = 2013

;

can any one help me.

Regards,

Antony.

Re: Where condition is not working in Cubes

Tue, 29 Jul 2014 17:06:39 GMT

Hi Antony,

If you need use the sentence where in the load of a cube, you have that add the follow line:

[$0SD_C03]:

Load *;

Select PseudoMDX D (

Dimensions (

[0CALYEAR] (),

[0FISCPER] ()),

Slices (

[0CALYEAR].[2013]),

From ($0SD_C03));

Please try with this code, but you may that check the value of the value field.

Regards!.

Alejandro Urrego