Report (display null based on some condition when the selections come from Inline Load)

Wed, 18 Dec 2013 03:49:02 GMT

Requirement:

Change the display in reports such that, if some condition is satisfied, it should display null in Xyz field.

The fields those are given as selection in UI, are coming from Inline Load in UI script

LOAD * INLINE [

%AdhocAccountDim,%AdhocAccountDimReal

Abc,Abc

Xyz,Xyz]

where %AdhocAccountDimReal -> refer to actual field Abc and Xyz in database.

%AdhocAccountDim -> Abc, Xyz present as selections on UI.

· In the report Xyz is selected as dimension with enable condition as

(getselectedcount(%AdhocAccountDim)>0 and max(aggr(if(%AdhocAccountDim='Xyz',1),%AdhocAccountDim))=1)

Issue : In Approach 1:

As soon as I put condition in existing 'Xyz' Dim in report, for creating a calculated dimension like :

=if(FLAG='Y',null(),Xyz)

The results in report are not displaying properly, the results for Flag = N is displaying fine but for Flag = Y getting something as sum( Yvalues) in expressions.

Issue : Approach 2:

If I create a new calculated dimension as Xyz New

=if(FLAG='Y',null(),Xyz) with same enable condition

(getselectedcount(%AdhocAccountDim)>0 and max(aggr(if(%AdhocAccountDim='Xyz',1),%AdhocAccountDim))=1)

and adding this in report, the result is only getting displayed properly if the original Xyz is also present along with new Xyz

Xyz(Original)

Xyz(new calculated dim)

Flag

Values

null

as soon as I remove the Xyz(original)

Xyz(new calculated dim)

Flag

Values

null

7 (sum of all Y values)

Expected Output :

Xyz(new calculated dim)	Flag	Values
null	Y	1
b	N	2
null	Y	1
null	Y	3
d	N	1
null	Y	2

Please provide some input.

Thanks !!

Re: Report (display null based on some condition when the selections come from Inline Load)

qlikpahadi07 — Wed, 18 Dec 2013 04:02:31 GMT

can you attach a Sample QVW

topic Re: Report (display null based on some condition when the selections come from Inline Load) in QlikView

Report (display null based on some condition when the selections come from Inline Load)

Re: Report (display null based on some condition when the selections come from Inline Load)