topic Re: need help in QlikView

need help

Wed, 25 Nov 2020 16:16:04 GMT

Hi Viewers,

I have table contains empty records

temp1:
load
functionname,
functionid,
fun_details
from <path\.qvd>

like this I have 5 tables(temp2,temp3,temp4,temp5)

am trying to showing count of records in front end

I have tried this but didn't work

tablename(dimension)---calculated dim--->valuelist('temp1','temp2','temp3','temp4','temp5')
num of records(expression) --->Pick(Match(valuelist('temp1','temp2','temp3','temp4','temp5'),'temp1','temp2','temp3','temp4','temp5'),
count(functionid),count(),count(),count(),count()))

Ultimately my desired output should be

In straight table

dim>tablename
field values should be

temp1
temp2
temp3
temp4
temp5

exp>no of records

corresponding values should be
0
0
0
0
0

Any ideas??

Re: need help

sspe — Tue, 25 Apr 2017 12:35:40 GMT

Hi,

Maybe I don't quite understand your requirement, but if you just want to have a table showing the tablename and the rowcount, then you can add a table and using the systemfields $Table and $Rows as fields.

Regards

Steen

Re: need help

Tue, 25 Apr 2017 15:05:07 GMT

Hi thanks for your reply!!

My desired output should be

tablename	no of records
temp1	0
temp2	0
temp3	0
temp4	0
temp5	0

Re: need help

MayilVahanan — Tue, 25 Apr 2017 15:47:14 GMT

try like this

temp1:

load * Inline

[

functionname, functionid, fun_details

];

temp3:

load * Inline

[

functionname3, functionid3, fun_details3

];

temp2:

load * Inline

[

functionname2, functionid2, fun_details2

];

FOR i = 0 to NoOfTables()-1

let vTableName = TableName($(i));

LOAD NoOfRows('$(vTableName)') as Rows, '$(vTableName)' as TableName AutoGenerate 1;

NEXT i;

use tablename as dimension and Rows as expression and uncheck suppress zero values in presentation tab.

temp1	0
temp2	0
temp3	0

Re: need help

Tue, 25 Apr 2017 16:18:46 GMT

Re: need help

Hi mayilvahanan‌, Thanks for your suggestion.

I want to show in dynamic.

Ie.,In future if there is any new are found we should display the count of records.

How to accomplish this scenario.

Please help!!

Re: need help

Peter_Cammaert — Tue, 25 Apr 2017 16:25:06 GMT

Mayilvahanan's solution will work for all tables you may load, whatever their name and whatever their field layout. If that's not enough, please tell us where you expect it to go wrong.

Re: need help

sspe — Wed, 26 Apr 2017 06:57:36 GMT

Both Mayilvahanan's solution as well as using the build-in $Tables and $Rows functions will work. If you don't agree, then I think you'll have to be let us know what it is in our suggestions that doesn't work you.

Personally I don't think it's neccessary to make a seperate routine for this becuase it's already existing functions.

Where the build in $Tables and $Rows functions doesn't work though, is in the cases where you don't want to show all tables. In that case it might be neccessary with the solution like Mayilvahanan's - but I don't see that being your requirement.

Regards

Steen