Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Static Straight Table

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Try this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

5 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

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.

Anil_Babu_Samineni

Try this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
its_anandrjs

Try this way also


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

Anonymous
Not applicable
Author

Thanks, Chouhan

But this expression is not working.