Qlik Community

App Development

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
sunny_talwar

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
sunny_talwar

May be this:

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

or

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

Not applicable
Author

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)

sunny_talwar

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

Not applicable
Author

Thanks, that works