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

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

eng19872 — Thu, 21 Feb 2019 08:11:04 GMT

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,

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

ahaahaaha — Thu, 21 Feb 2019 11:05:56 GMT

Hi,

May be like in the attached file?

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

ahaahaaha — Thu, 21 Feb 2019 11:10:00 GMT

Source data file

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

eng19872 — Thu, 21 Feb 2019 12:03:50 GMT

Hi, please check original datafile.xlsx file.

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

eng19872 — Thu, 21 Feb 2019 12:04:55 GMT

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

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

ahaahaaha — Fri, 22 Feb 2019 13:07:05 GMT

Then maybe as attached file?

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

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

eng19872 — Fri, 22 Feb 2019 14:01:40 GMT

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

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

eng19872 — Fri, 22 Feb 2019 14:31:44 GMT

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?

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

ahaahaaha — Fri, 22 Feb 2019 14:34:22 GMT

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

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

ahaahaaha — Fri, 22 Feb 2019 14:38:55 GMT

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