Qlik Community

Qlik Sense App Development

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

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

Re: Ignore filters

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

Count(DISTINCT TOTAL codcli)

4 Replies
MVP
MVP

Re: Ignore filters

May be this:

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

or

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

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)

MVP
MVP

Re: Ignore filters

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

Count(DISTINCT TOTAL codcli)

Not applicable

Re: Ignore filters

Thanks, that works