Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
eng19872
New Contributor III

Show / Hide Negative and Positive Values in Pivot Table Row

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 1Dim 2Months            
  Total ColumnM1M2M3M4M5M6M7M8M9M10M11M12
Region 1Area 1-36123456-7-8-9-10-11-12
Region 1Area 236-1-2-3-4-5-6789101112
               
               
Required - Output if Total is Negative           
Dim 1Dim 2Months            
  TotalM1M2M3M4M5M6M7M8M9M10M11M12
Region 1Area 1-36123456-7-8-9-10-11-12
               
               
Required - Output if Total is Positive           
Dim 1Dim 2Months            
  TotalM1M2M3M4M5M6M7M8M9M10M11M12
Region 1Area 236-1-2-3-4-5-6789101112
4 Replies
shiveshsingh
Honored Contributor

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

Hi

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

Just give it a try

eng19872
New Contributor III

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

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,

shiveshsingh
Honored Contributor

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

Can you share input file? 

eng19872
New Contributor III

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

Current output and required output is given in attached file.