topic Re: Can we create Straight Table using Direct Discovery in QlikView

Can we create Straight Table using Direct Discovery

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Can we create Straight Table using Direct Discovery

Re: Can we create Straight Table using Direct Discovery

sunny_talwar — Wed, 26 Oct 2016 11:14:14 GMT

I think so but you can only use measures for expressions. I think Dimensions won't be able for expressions.

Re: Can we create Straight Table using Direct Discovery

sunny_talwar — Wed, 26 Oct 2016 11:15:12 GMT

Check this:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/DirectDiscovery/How_To_Create_Charts_Direct_Discover…

Re: Can we create Straight Table using Direct Discovery

avinashelite — Wed, 26 Oct 2016 11:21:49 GMT

Yes, you can but as Sunny mentioned ..Measures cannot be the part of dimension and be careful with volume of data

Re: Can we create Straight Table using Direct Discovery

Anonymous — Wed, 26 Oct 2016 11:25:13 GMT

Thanks for the post, I want to add the where clause, inside direct query like -

suppose, I have columns in direct query like -

col1, col2,col3

where col1 is having OSUser details, now if col1 is logged in user, I want to show col2 and col3 in either text box or in straight table.

I tried with Max function as per above link and also with where clause, but doesn't work.

any inputs.

Re: Can we create Straight Table using Direct Discovery

sunny_talwar — Wed, 26 Oct 2016 11:28:28 GMT

You used Where clause in the front end object? I think for the front end object, try with If statement...

Just out of curiosity what is the expression you are trying right now?

Re: Can we create Straight Table using Direct Discovery

Anonymous — Wed, 26 Oct 2016 11:28:36 GMT

I have created a flag for dimension.

But Not able to fetch the data inside chart using where clause.

in above example, col1, col2 and col3 are measures only.

Re: Can we create Straight Table using Direct Discovery

Anonymous — Wed, 26 Oct 2016 12:23:32 GMT

I tried to use IF statement, like -

if(col1=OSUser(),col2)

But no luck....

Any help on this

Re: Can we create Straight Table using Direct Discovery

stabben23 — Wed, 26 Oct 2016 13:17:02 GMT

add all values in a tablebox, made a screenshot and explain what you try to do.

Re: Can we create Straight Table using Direct Discovery

stabben23 — Wed, 26 Oct 2016 13:25:59 GMT

ok, Measure is only visible with an aggregation like Sum(col1)

Re: Can we create Straight Table using Direct Discovery

sunny_talwar — Wed, 26 Oct 2016 13:49:03 GMT

This is a layout condition or displaying the value of col1? Also is there only one value to see? May be you need to use Concat() function here?

Concat(if(col1=OSUser(),col2))

Re: Can we create Straight Table using Direct Discovery

Anonymous — Thu, 27 Oct 2016 05:56:19 GMT

This does not work...

When I try to fetch the values inside text box, it says, "Error: Internal fatal error".

Re: Can we create Straight Table using Direct Discovery

stabben23 — Thu, 27 Oct 2016 06:21:20 GMT

Can you show us the script?

Re: Can we create Straight Table using Direct Discovery

sunny_talwar — Thu, 27 Oct 2016 08:46:17 GMT

OSUser() usually gives more than just the username, it gives the domain name and then the username. Does your col1 include the exact match of OSUser()? May be you want to use a wildmatch?

Concat(if(WildMatch(OSUser(), '*\' & col1), col2))

Concat(if(col1 = SubField(OSUser(), '\', 2), col2))