Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
shaik_basha
Contributor III

Re: How to show total number or records?

Hi tahirghalib,

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

Thanks



Not applicable

Re: How to show total number or records?

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

jonbrough
Valued Contributor

Re: How to show total number or records?

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

Re: How to show total number or records?

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

Re: How to show total number or records?

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

shaik_basha
Contributor III

Re: How to show total number or records?

Hi tahirghalib,

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

Thanks


Community Browser