Qlik Sense - Show / Hide Negative and Positive Values in Table Row

[eng19872]

Hi,

I have given below "Current Output" in Qlik Sense, 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.

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

Please share me the solution.

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

regards,

[ahaahaaha]

Hi,

May be like in the attached file?

[ahaahaaha]

Source data file

[eng19872]

Hi, please check original datafile.xlsx file.

[eng19872]

Hi, one row will come at the same time. if filter is selected then negative value show otherwise positive value show.

[ahaahaaha]

Hi

Then maybe as attached file?

It is necessary when setting the table to remove the flag in the advanced settings "show zero values"

[eng19872]

Can I do the same in Qlik Sense Pivot table? if yes please share me.

[eng19872]

I am little bit confuse about the file as you shared me. Can you confirm me are you using my shared file as data source or you made any changes before to load in Qlik Sense?

[ahaahaaha]

May be as Pivot table on sheet 2 in attached file?

[ahaahaaha]

Your source file has been slightly modified. I attached it above and once again do it here