Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Total is nothing but a chart used here.
and in Dimension, there is no parameter added.
HI @Mauritz_SA , can you please look into the issue.
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
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?
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)?
You can reduce application size and share here. Check: https://community.qlik.com/t5/QlikView-Documents/Preparing-examples-for-Upload-Reduction-and-Data-Sc...
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?
Total is nothing but a chart used here.
and in Dimension, there is no parameter added.
This looks like a straight table, can't you use Sum of rows to show the total?