Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)