Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Architect
Creator
Creator

Set Analysis

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)

Labels (3)
1 Solution

Accepted Solutions
Architect
Creator
Creator
Author

Total is nothing but a chart used here.

and in Dimension, there is no parameter added.

View solution in original post

19 Replies
Architect
Creator
Creator
Author

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

Mauritz_SA
Partner
Partner

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
MVP
MVP

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
Creator
Creator
Author

HI @tresesco ,

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

Please have a look.

tresesco
MVP
MVP

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
MVP
MVP

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
Creator
Creator
Author

Total is nothing but a chart used here.

and in Dimension, there is no parameter added.

View solution in original post

sunny_talwar

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