Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show total number or records?

Hi,

I have attached a sample qvw in which I want to show total number of records of a chat table in a tex box.

There are two chart tables in the sample file, one is with IF and one with SET.

Total number of records need to be shown for both types of tables seperately, as you can see two seperate taxt boxes.

Can some one help me out writing expression?

Currently I am using following

     =Sum(Aggr( <your table expression> , <table dimension 1>, <table dimension 2>, ...))

But it not showing the correct number of records.

Your input will be highly appreciated.

Thanks,

TA

6 Replies
Anonymous
Not applicable
Author

Hi tahirghalib,

  Can you pleae explaining about inputbox importance and provide a sample excel data.

Thanks



Not applicable
Author

Hi Shaik,

Thanks for your reply.

Here is the explanation of the inputbox.

There are three types of inputboxs:

1. Input boxes (varialbes) which has coparison signs for User Comments in different time periods

2. Input boxes (varialbes) which have values for User Comments in different time periods

3. Input boxes (variables) which are combination of first inputboxes. And this third type of input boxes are used in the expressions. which means when user select

For example when user select for example:

User comments in 4 WKS ">= 0"  and

User comments in 4 WKS ">= 0" and

User comments in 4 WKS ">= 0"

chart table will show the records which fulfill all these three conditions.

I have attached sample exacel sheets as well.

Please let me know if you have any questions.

Thanks,

TA

Anonymous
Not applicable
Author

Sorry to have to resort to this, but a macro might help:

set obj1 = ActiveDocument.GetSheetObject( "CH02" )

ActiveDocument.Variables("RowCount1").SetContent obj1.GetRowCount, true

set obj2 = ActiveDocument.GetSheetObject( "CH08" )

ActiveDocument.Variables("RowCount2").SetContent obj2.GetRowCount, true

You could then use RowCount1 and 2 in your text box.

It would be tricky to make it dynamic though, and I don't know if it would be supported in Ajax.

Jonathan

Gysbert_Wassenaar

See attached qvw. I've changed the data model a bit so the expressions become simpler. I've also had to add all the AU ID's from the User Comments files to the Users table. Otherwise the + operator wouldn't work correctly to find the right set of AU ID's to calculate the number of rows.

edit: added a v5 version which should solve a problem.


talk is cheap, supply exceeds demand
Not applicable
Author

In v4, the chart table is not giving the correct answer through.

How would you implement "and" condition between all three selections for user comments?

e.g.

UC4WKS>1

UC26WKS>5

UC52WKS>6

Chart should only show the records which fulfill above three conditions.

Currently it is not...

Anonymous
Not applicable
Author

Hi tahirghalib,

   I have one doubt how mutch of count of id is correct

Thanks