Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Part of expression which ignores dimension

How can get one part of an expression (bold and underlined) to ignore a dimension on a bar chart (in this case CalendarDate), but NOT the other part?

COUNT(DISTINCT UserName)  /  COUNT(DISTINCT UserName)

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

COUNT({$<CalendarDayName-={'Sat','Sun'},UserName-={"*test*"}>} DISTINCT UserName)

/

COUNT(TOTAL {$<CalendarDayName-={'Sat','Sun'},UserName-={"*test*"},SessionStartedDate = >} DISTINCT UserName)

View solution in original post

5 Replies
MK_QSL
MVP
MVP

COUNT(DISTINCT UserName)  /  COUNT( {<Dimension1Name = , Dimension2Name = >}DISTINCT UserName)

Not applicable
Author

And if I only had one dimension it would be as follows?

COUNT(DISTINCT UserName)  /  COUNT( {<Dimension1Name = >}DISTINCT UserName)

maxgro
MVP
MVP

you can find the answer above,

or in online help

     sum( {$<Region = >} Sales )
     returns the sales for the current selection, but with the selection in “Region” removed.

or in the doc of Aunez Fabrice (if you have time)

Set Analysis: syntaxes, examples

Not applicable
Author

My full expression is actually;

COUNT({$<CalendarDayName-={'Sat','Sun'},UserName-={"*test*"}>} DISTINCT UserName)

/

COUNT({$<CalendarDayName-={'Sat','Sun'},UserName-={"*test*"},SessionStartedDate = >} DISTINCT UserName)

The only dimension is SessionStartedDate

But it doesn't seem to work. It just comes out as 100%, which means it isn't ignoring the dimension

MK_QSL
MVP
MVP

COUNT({$<CalendarDayName-={'Sat','Sun'},UserName-={"*test*"}>} DISTINCT UserName)

/

COUNT(TOTAL {$<CalendarDayName-={'Sat','Sun'},UserName-={"*test*"},SessionStartedDate = >} DISTINCT UserName)