topic Show / Hide Negative and Positive Values in Pivot Table Row in QlikView

Show / Hide Negative and Positive Values in Pivot Table Row

eng19872 — Sat, 16 Nov 2024 04:22:54 GMT

Hi,

I have given below "Current Output" and now I would like to make change.

I have filter called "Negative Values". When I make selection in filter Negative Value then the row Negative Value will show where the total is in negative otherwise positive row will show and come always if filter is not selected.

Current and required outputs are also given below, however I am attaching the data source file with scenario.

Filter Negative Values



Current Output
Dim 1	Dim 2	Months
		Total Column	M1	M2	M3	M4	M5	M6	M7	M8	M9	M10	M11	M12
Region 1	Area 1	-36	1	2	3	4	5	6	-7	-8	-9	-10	-11	-12
Region 1	Area 2	36	-1	-2	-3	-4	-5	-6	7	8	9	10	11	12


Required - Output if Total is Negative
Dim 1	Dim 2	Months
		Total	M1	M2	M3	M4	M5	M6	M7	M8	M9	M10	M11	M12
Region 1	Area 1	-36	1	2	3	4	5	6	-7	-8	-9	-10	-11	-12


Required - Output if Total is Positive
Dim 1	Dim 2	Months
		Total	M1	M2	M3	M4	M5	M6	M7	M8	M9	M10	M11	M12
Region 1	Area 2	36	-1	-2	-3	-4	-5	-6	7	8	9	10	11	12

Re: Show / Hide Negative and Positive Values in Pivot Table Row

shiveshsingh — Thu, 21 Feb 2019 08:46:34 GMT

Why don't you try with enable condition during defining Dimensions?

Just give it a try

Re: Show / Hide Negative and Positive Values in Pivot Table Row

eng19872 — Thu, 21 Feb 2019 09:48:30 GMT

Hi,

Conditional Show / Hide is not a problem, but the problem is to show only Negative Values.

Example:

Total Value is in Negative, then when I make expression on the behalf of total then only negative value appear in whole row so How to show positive values as well in the same row when filter Negative Value is selected.

Please have a look into the excel file for current and required output.

Thanks,

Re: Show / Hide Negative and Positive Values in Pivot Table Row

shiveshsingh — Thu, 21 Feb 2019 09:53:54 GMT

Can you share input file?

Re: Show / Hide Negative and Positive Values in Pivot Table Row

eng19872 — Thu, 21 Feb 2019 10:06:33 GMT

Current output and required output is given in attached file.