topic Re: Static Straight Table in QlikView

Static Straight Table

Anonymous — Thu, 12 Oct 2017 05:11:38 GMT

Dear, All

Good Morning!

Today morning I was trying to freeze the straight table values.

I Succeeded to freeze one expression, but I got stuck on other.

So can anyone help me in fixing the other problem?

Thanks in Advance

Re: Static Straight Table

Anil_Babu_Samineni — Thu, 12 Oct 2017 05:14:26 GMT

Looks like you have some values? What are you going to have instead 0's ??

Re: Static Straight Table

Anonymous — Thu, 12 Oct 2017 05:23:48 GMT

Yes, Anil

You are right; Straight table has values. However, as I selected oct month, so it is reflecting oct month value, but i want values for all the months.

It should n't have any link with selection of months.

As an example, I did for the first expression.

Re: Static Straight Table

Anil_Babu_Samineni — Thu, 12 Oct 2017 05:26:49 GMT

Try this?

=Num(Count({1<Comments = {"Duplicate"}>} Comments), '##,##,###')

Re: Static Straight Table

its_anandrjs — Thu, 12 Oct 2017 06:06:59 GMT

Try this way also

=Num(Count( {1} {<Comments = {"Duplicate"}>} Comments), '##,##,###')

Re: Static Straight Table

Anonymous — Thu, 12 Oct 2017 06:09:23 GMT

Thanks, Chouhan

But this expression is not working.