Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
bijay_jha
Creator
Creator

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), '##,##,###')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

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 ??

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bijay_jha
Creator
Creator
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), '##,##,###')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

its_anandrjs

Try this way also


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

bijay_jha
Creator
Creator
Author

Thanks, Chouhan

But this expression is not working.