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' } , [Language] = { 'English' }, Format -= {'A4'} >} [URL] ) ) )
that I know works, but includes all assets categorized as SFDC or Qlik.com, not only those that are both.
Thanks!
I believe it would be:
Count(DISTINCT {
(
< [LOCATION] = { 'SFDC' } >
* < [LOCATION] = { 'Qlik.com' } >
)
* < [Language] = { 'English' }, Format -= {'A4'} >
} [URL] ) ) )
-Rob
I believe it would be:
Count(DISTINCT {
(
< [LOCATION] = { 'SFDC' } >
* < [LOCATION] = { 'Qlik.com' } >
)
* < [Language] = { 'English' }, Format -= {'A4'} >
} [URL] ) ) )
-Rob
Hi Meghann,
try like this
Count({<URL=P({<LOCATION={'SFDC'}>})*P({<LOCATION={'Qlik.Com'}>}),Language={'English'},Format-={'A4'}>} DISTINCT URL)
and
Concat({<URL=P({<LOCATION={'SFDC'}>})*P({<LOCATION={'Qlik.Com'}>}),Language={'English'},Format-={'A4'}>} DISTINCT URL,' - ')
Regards,
Antonio
Hello Meghann,
Try this,
=Count(DISTINCT {< [LOCATION] = { 'SFDC*','Qlik.com*' } , [Language] = { 'English' }, Format -= {'A4'} >} [URL] ) ) )
Hope this helps!
Hi Meghann,
The below translates to
LOCATION = SFDC OR Qlik.com
[LOCATION] = { 'SFDC','Qlik.com' }
To have the AND condition you will need * operator which will look for intersecting records between the two sets
https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/
Hello,
Where would I put the concat function?
Thank you
If You want to know which URLs are.