topic Re: Rows count in Bar chart in App Development

Rows count in Bar chart

nsetty — Mon, 31 Oct 2016 19:34:32 GMT

I have spreadsheets with data, how can I represent row count in each spreadsheet in bar chart

Re: Rows count in Bar chart

shraddha_g — Tue, 01 Nov 2016 08:42:40 GMT

can you elaborate with sample data n sample output?

Re: Rows count in Bar chart

marcohadiyanto — Wed, 02 Nov 2016 07:49:11 GMT

Hi Nagesh

First load your excel data and add this script rowno() as row this script automatically generate number of row that you have.

Then in your layout, you can use max(row) or count(row).

You can learn more about functions in Qlik Sense.

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/functions-in-scripts-chart-expressions.htm

https://help.qlik.com/en-us/sense/1.1/pdf/Script%20Syntax%20and%20Chart%20Functions%20Guide.pdf

Regards,

Marco

Re: Rows count in Bar chart

nsetty — Thu, 03 Nov 2016 14:53:30 GMT

Newbie to QlikSense community - Very trivial question

Spreadsheet 1 - Source System 1 - Row count - 20k

Spreadsheet 2 - Source System 2 - Row count - 12k

Spreadsheet 3 - Source System 3 - Row count - 10k

Spreadsheet 4 - Source System 4 - Row count - 120k

Spreadsheet 5 - Source System 5 - Row count - 25k

Data load varies each day.. Have to represent row counts of various spreadsheets in a chart.

Thanks

Nagesh

Re: Rows count in Bar chart

shraddha_g — Fri, 04 Nov 2016 03:52:32 GMT

Create a Dimension with Valuelist() as

Valuelist('Source System 1','Source System 2','Source System 3','Source System 4','Source System 5')

in Measure

USe

Pick(wildmatch(Valuelist('Source System 1','Source System 2','Source System 3','Source System 4','Source System 5'),'Source System 1','Source System 2','Source System 3','Source System 4','Source System 5'),

Count([Field from Source System 1]),

Count([Field from Source System 2]),

Count([Field from Source System 3]),

Count([Field from Source System 4]),

Count([Field from Source System 5])

)

Re: Rows count in Bar chart

krishna20 — Fri, 04 Nov 2016 05:25:18 GMT

Hi,

Better you concatenate and create flag and use flag in expression you will get seperate count for each spread sheet

spread sheet1

filename() as flag

concatenate

spread sheet 2

filename() as flag

concatenate

filename() as flag

spread sheet 3

Re: Rows count in Bar chart

jonathandienst — Fri, 04 Nov 2016 06:00:14 GMT

Edit the LOAD statement to something like:

LOAD ...

<load fields from spreadsheets>

...

1 as RowCount,

RowNo() as rowID,

FileBaseName() as Source

FROM ;

Then you can use Source as a dimension and Sum(RowCount) as a metric to show the loaded data stats.

(adjust the script to match your exact requirements)

Re: Rows count in Bar chart

nsetty — Fri, 04 Nov 2016 14:35:10 GMT

Tried with adding measure -

Pick(WildMatch(ValueList('Source System 1'), Count[field in source system 1] ));

When pulled into Bar chart getting

"An error occurred"

"Internal engine error"

Tried hardcoding the values - Pick(WildMatch(ValueList('Source System 1''), 100 ))

Even then received error.

Thanks

Nagesh

Re: Rows count in Bar chart

shraddha_g — Mon, 07 Nov 2016 07:01:37 GMT

what is the dimension you used before adding the measure?

Re: Rows count in Bar chart

nsetty — Mon, 07 Nov 2016 13:55:04 GMT

Created Dimension using valuelist function

Create a Dimension with Valuelist() as

Valuelist('Source System 1','Source System 2','Source System 3','Source System 4','Source System 5')

Re: Rows count in Bar chart

shraddha_g — Tue, 08 Nov 2016 11:50:39 GMT

Tried hardcoding the values - Pick(WildMatch(ValueList('Source System 1''), 100 ))

use Pick(wildmatch(Valuelist('Source System 1','Source System 2','Source System 3','Source System 4','Source System 5'),'Source System 1'), 100 )