topic Re: Issue in Building A Trendy Chart in QlikView

Issue in Building A Trendy Chart

vishnumusani — Wed, 25 Nov 2020 16:16:04 GMT

HI All,

We would like to display only those Country and specific issue which is repeatedly happening over a specified period of time and Cost occurred for the same as a Trendy Chart. Could someone please guide me how to do the same.

I am attaching a sample file along with required data as a bar chart in pivot table.

Thanks,

MVR

Re: Issue in Building A Trendy Chart

ogautier62 — Fri, 31 Aug 2018 12:52:23 GMT

Hi,

I hope it is the expected result :

replace dimension Issue by :

if(aggr(nodistinct count(distinct Period), Country,Issue)=count(total distinct Period),Issue)

regards

Re: Issue in Building A Trendy Chart

trdandamudi — Fri, 31 Aug 2018 13:12:43 GMT

See the attached and hope this helps: