Can we create Straight Table using Direct Discover... - Qlik Community

Anonymous · ‎2016-10-26

Can we create Straight Table using Direct Discovery

sunny_talwar · ‎2016-10-26

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

sunny_talwar · ‎2016-10-26

Check this:

avinashelite · ‎2016-10-26

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

Anonymous · ‎2016-10-26

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.

sunny_talwar · ‎2016-10-26

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?

Anonymous · ‎2016-10-26

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.

Anonymous · ‎2016-10-26

I tried to use IF statement, like -

if(col1=OSUser(),col2)

But no luck....

Any help on this

stabben23 · ‎2016-10-26

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

stabben23 · ‎2016-10-26

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