Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Ignore filters

Hi all, i have this situation

1 colum expresion:

DesNivArt1

2 colum expresion:

Count( distinct codcli)


3 colum expresion:

(Count( distinct codcli)/

COUNT({1} DISTINCT ALL codcli))*100

anoVtaCab is a year like 2016 - 2015 - 2014...


DesNivArt1 is the company that provide me the items I sale... in 2 i know how many clients buy an item of the company... in the 3 colum i know the percent of customers that purchase an item of the company, compare to the total customers i have (all customers)... now i want to know the percent of clients compare to the customers who bought me in the selected year. For example

     total clients of "DesNivArt=01"

-----------------------------------------------------  X 100

total clients i sale in a year selected

qlik.pngqlik2.png

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Ignore filters

Not sure where you came up with 100 and 50, but may be this to ignore dimension

Count(DISTINCT TOTAL codcli)

View solution in original post

4 Replies
Highlighted

Re: Ignore filters

May be this:

Count({<Year>}DISTINCT codcli)/Count(DISTINCT codcli) * 100

or

Count({1}DISTINCT codcli)/Count(DISTINCT codcli) * 100

Highlighted
Not applicable

Re: Ignore filters

The problem is that those expresions consider "DesNivArt1", i want my expresion not to consider the dimension "desnivart"... so if i selected year = 2016 total customers should be 100 and no only 50 (the ones that buy items from a specific DesNivArt1)

Highlighted

Re: Ignore filters

Not sure where you came up with 100 and 50, but may be this to ignore dimension

Count(DISTINCT TOTAL codcli)

View solution in original post

Highlighted
Not applicable

Re: Ignore filters

Thanks, that works