topic Re: Bar Chart by Max Deployedate wise FullUser in QlikView

Bar Chart by Max Deployedate wise FullUser

sona_sa — Tue, 16 Jun 2015 06:56:22 GMT

Hi I have some data on behalf of SubcompanyEntity wise FullUser Information with deploydate.

Now I want a bar chart SubcompanyEntity wise Max of Deployedate wise Sum of FullUser.

It Is giving me one output.

But I have 9 SubcompanyEntity.

Regards,

ankit777 — Tue, 16 Jun 2015 07:02:34 GMT

Hi,

Try using below expression

=Sum({<[DeployedDate ] = {"=max([DeployedDate ]"}>} NoOfLicense)

sona_sa — Tue, 16 Jun 2015 07:29:40 GMT

Please check the output.

Attached Out is not correct - I use the same - =Sum({<[DeployedDate ] = {"=max([DeployedDate ]"}>} NoOfLicense)

Thanks for reply

ankit777 — Tue, 16 Jun 2015 08:03:34 GMT

Both of your table are not linked to each other. am I missing something?

ankit777 — Tue, 16 Jun 2015 08:05:47 GMT

that's y its showing same value against all country

sona_sa — Tue, 16 Jun 2015 08:12:08 GMT

Please find the attached qvw for ref.