Set Analysis

[Architect]

Hi, there are two parts in my question

Part1>

I am having one problem related to one field "Sellable items", that contains below-given logic.

Can you please help me understand this logic:-->

"if(match(getcurrentfield(Range_Structure),'RU','Purchasing Area (POA)','Purchasing Team','Supplier','Purchasing Group','Range Status')=0,

(num(Count({<[Range Status]=,SnapNo={1}, HAVE_ASSESMENT={1},[Item Status]={Sellable}>}DISTINCT [Item No])
/
Count({<[Range Status]=,SnapNo={1}, HAVE_ASSESMENT=,[Item Status]={Sellable}>}DISTINCT [Item No])
,'# ##0,0%')),'')"

Part2>

There are 4 columns in my chart and "Sellable items" is one of them. After adding some filter, 2 rows are selected.

In 1st row "Sellable items" = 73,8%

and in 2nd row the values are = 0,0%. when I am selecting the total value by the expression, I am having a result of 74,3%.

My goal is to neglect the 2nd  row where column "Sellable items" = 0,0% so the total become 73,8% (same as 1st row)

[Architect]

HI @Mauritz_SA , can you please look into the issue.

[Mauritz_SA]

Hi @Architect 

This is quite a complex question. I have only worked in Qlik Sense and not QlikView and getcurrentfield is not a valid function in Qlik Sense.

In Part 1 it seems as if you only want to do the calculation when the Range_Structure is not one of the following: 'RU','Purchasing Area (POA)','Purchasing Team','Supplier','Purchasing Group','Range Status'.

The rest of the calculation basically wants the number of Items which have a HAVE_ASSESMENT value of 1 out of all of the items while disregarding the [Range Status] selection and only looking at items which have a 'Sellable' [Item Status] and a SnapNo of 1. I think the Sellable needs to be in single or double quotes.

As for Part 2, I am not sure, but maybe someone like @sunny_talwar can assist.

Regards,

Mauritz

[tresesco]

Hi Gaurab,

To extend what @Mauritz_SA  has said, 

Part1> You are probably having a group (cyclic/drill down) in chart called 'Range_Structure'. And then as stated by Mauritz, this calculation is expected to be in action when none of those fields are in chart being active. 

Part2> 

....2nd row the values are = 0,0%. when I am selecting the total value by the expression, I am having a result of 74,3%....

Could not really follow this. Could you explain with screen shot or a sample app attached? 

[Architect]

HI @tresesco ,

I have attached one word Doc here to explain the issue.

Please have a look.

[tresesco]

Hi,

You have created the document nicely to include details possible. Are you overlapping objects (textbox/straight table)? It seems you are using the very same expression for your 'total' row. However, I am not sure it is really context/dimension sensitive or not. You have shared lot of actual information, can you also share the sample app (remove all charts,data and then share)?

[tresesco]

You can reduce application size and share here. Check: https://community.qlik.com/t5/QlikView-Documents/Preparing-examples-for-Upload-Reduction-and-Data-Sc...

[sunny_talwar]

Where exactly are you using an expression for Total? All I am seeing in each of the screenshot is a reference for Sellable Iteams.... Where exactly are you adding Total expression?

[Architect · Accepted solution]

Total is nothing but a chart used here.

and in Dimension, there is no parameter added.

[sunny_talwar]

This looks like a straight table, can't you use Sum of rows to show the total?