Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to format a gauge to count all URL's that have a Location = SFDC AND a Location = Qlik.com. I cannot get my function to work as I don't know the proper formatting. So far, I have
Count(DISTINCT{<[LOCATION] ={"SFDC","Qlik.com"}>}[URL])
that I know works, but includes all assets were Location = SFDC OR Location=Qlik.com
If possible, I would also like to narrow this down further to include only Language=English and Format<>A4. This is my starting point...
Count(DISTINCT{<[LOCATION] ={"Qlik.com"} and ([Language] = {"English"}>}[URL]))) etc.
Thanks!
This expression you try this ways
1. Where LOCATION = SFDC,Qlik.com try this with single comma
=Count(DISTINCT{<[LOCATION] = { 'SFDC','Qlik.com' } >} [URL] )
2. I assume language = English and format <> A4
=Count(DISTINCT {< [LOCATION] = { 'SFDC','Qlik.com' } , [Language] = { 'English' }, Format -= {'A4'} >} [URL] ) ) )
Note:- In SET expression you have not to use AND OR.
This function works perfectly I think! Only issue is this would be my 'denominator', because the comma in {< [LOCATION] = { 'SFDC','Qlik.com' } acts as an OR, so instead of including the inside of the venn diagram, i get the outside. I want to divide all the assets that have BOTH by all the assets that are either, the latter of which is this function. Thank you!!