topic Re: help needed in QlikView

help needed

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

Hi Folks,

I have dummy data to create Gander diversity

but am not getting what exactly am looking for !!!

I want to see my out put as per my below snap shot

Can someone help me out from this??

PFB for for your reference!!!

techvarun — Thu, 17 Aug 2017 02:54:24 GMT

Hi,

Check the attached.

antonybi — Thu, 17 Aug 2017 03:58:37 GMT

Yes i have tried the same.

But

In snap shot, There are only 2 legends(Male and Female).

also have dimensions count by Gander and % by Gander

which is not showing .

Pls suggest!!

devarasu07 — Thu, 17 Aug 2017 04:39:30 GMT

Hi,

Try to use Valuelist method,

Dimension:

=Valuelist('Female','Male')

Measure:

Count by Gendar

If(ValueList('Female', 'Male')='Female',Count({$<gendar = {'F'}>}id),

If(ValueList('Female', 'Male')='Male',Count({$<gendar = {'M'}>}id)))

% by Gendar

If(ValueList('Female', 'Male')='Female',Count({$<gendar = {'F'}>}id)/Count(TOTAL id),

If(ValueList('Female', 'Male')='Male',Count({$<gendar = {'M'}>}id)/Count(TOTAL id)))

antonybi — Thu, 17 Aug 2017 04:53:14 GMT

Almost closed but my dimensions are Count by Gander and % by Gander

and also have legends are Male and Female.

Can you please kindly look at??

tresB — Thu, 17 Aug 2017 05:42:49 GMT

Like this?

rahulpawarb — Thu, 17 Aug 2017 05:44:15 GMT

Please refer attached sample application.

Hope this will help.

Regards!

Rahul Pawar