topic Re: Assist with Expression in QlikView

Assist with Expression

QFanatic — Sat, 16 Nov 2024 01:22:57 GMT

Please find attached.

so the Data looks as given.

I need to create a chart (below) that looks like the desired output. Hope you can assist!

Thanks

Re: Assist with Expression

petter — Fri, 31 Jan 2020 11:21:38 GMT

I presume that the first table you show is a table that is exactly like that in the Data Model as a data table and not a UI table having aggregates...

If so then simply create a UI regular table in a sheet:

1) Create a dimension with the field [Table]

2) Create a measure with the following expression: Count( [Table] )

And you will get what you asked for....

Re: Assist with Expression

sayalip — Wed, 05 Feb 2020 15:16:27 GMT

Hi,

create a straight or pivot table with dimension table and expression =aggr(count (cardno),table)