Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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.