topic Re: filtered straigth table with expressions in QlikView

filtered straigth table with expressions

Anonymous — Thu, 19 Jul 2018 13:28:34 GMT

Hello,

I stuck currently in a maybe simple question.

I have a straight table with several dimensions and expressions.

When I filter the straight table by a criteria I get only those lines where the expression has a result.

But the whished result is a list which shows all lines, also lines with null values from the expressions.

I tried already to deactivate the settings for "display zero values" within the dimension and presentation tab.

And when I try to use an expression like

count ( {1 < CONTACT = {'visit'} >} [CONTACT] )

the filter value is completely ignored.

Many thanks in advance for your help and best regards,

Claus

Re: filtered straigth table with expressions

Anil_Babu_Samineni — Thu, 19 Jul 2018 13:31:16 GMT

Try this?

count ( {< CONTACT = {'visit'}, [ZM PR]=>} CONTACT)

Re: filtered straigth table with expressions

sunny_talwar — Thu, 19 Jul 2018 13:32:46 GMT

Null values in which dimension? Can you provide some more details here

Re: filtered straigth table with expressions

Anonymous — Thu, 19 Jul 2018 13:42:05 GMT

I want to get also addresses as result where the result of calculated expressions is null.
In that example I expect a line with an address where the #visits 12M = 0.

Using [ZM PR]= within set analysis leads to the same result like count ( {1...

BR,

Claus

Re: filtered straigth table with expressions

sunny_talwar — Thu, 19 Jul 2018 13:44:15 GMT

Might be easy to see the problem if you are able to share a sample?

Re: filtered straigth table with expressions

Anonymous — Thu, 19 Jul 2018 13:57:30 GMT

I can only provide screenshots from the settings...

In this test object I have currently only one expression.

Hope this helps?

BR,

Claus

Re: filtered straigth table with expressions

sunny_talwar — Thu, 19 Jul 2018 14:01:15 GMT

Can you create the issue in a mock file? If not, then I am not really sure how to help. I hope loveisfail‌ or somebody else is able to help in that case.

Best,

Sunny

Re: filtered straigth table with expressions

ogautier62 — Thu, 19 Jul 2018 14:08:05 GMT

Hi,

all your columns seem to be in dimension; but the only expression

so remove one column as dimension if you can,

or add a column : value = 1 and you hide it

regards

Re: filtered straigth table with expressions

Anonymous — Thu, 19 Jul 2018 14:19:13 GMT

I tried already to add an expression like =1 and hided it within the presentation tab.

But the result was the same, the calculated expression suppress the lines with 0 visits.

Can you please explain your thought about to "remove one column from the dimensions"?

Re: filtered straigth table with expressions

ogautier62 — Thu, 19 Jul 2018 14:27:40 GMT

and check too 'display all values'

maybe street, zip, city don't need to be dimension, try as expression

Re: filtered straigth table with expressions

Anonymous — Thu, 19 Jul 2018 14:41:28 GMT

Many thanks, now I get it!

I moved the dimension city into the expressions ( =only(city) ) and know I get also the zero lines displayed!

Best regards,

Claus

Re: filtered straigth table with expressions

ogautier62 — Thu, 19 Jul 2018 14:43:54 GMT

thanks

ok good dev

Re: filtered straigth table with expressions

Anil_Babu_Samineni — Thu, 19 Jul 2018 14:45:06 GMT

I hope He got answer

Re: filtered straigth table with expressions

Anonymous — Thu, 19 Jul 2018 14:49:42 GMT

I do, many thanks also for your answer!

BR,

Claus