topic Re: Basic % expression help in QlikView

Basic % expression help

Fri, 08 Mar 2013 12:05:22 GMT

New to QlikView and don't know how to create a percentage expression for string field with 2 values in a chart.

Re: Basic % expression help

manideep78 — Fri, 08 Mar 2013 12:09:38 GMT

right click--> properties--> go to number tab(select a field for which you want to show in %)--> check show in percent option.

Re: Basic % expression help

Fri, 08 Mar 2013 12:11:40 GMT

Hello Racine,

You can add a new expression with Field1/Field2 and then on Number Tab, select that expression and select Number radio button and then Show in Percent checkbox.

Thanks,

itsangad

Re: Basic % expression help

Fri, 08 Mar 2013 12:13:13 GMT

Thanks but my problem is even more basic than that. I don't know how to create a percentage expression e.g.

"Male" and "Female" values in field "Gender".

Re: Basic % expression help

Fri, 08 Mar 2013 12:14:33 GMT

It's a percentage in the same string field e.g. "Male" and "Female" in field "Gender".

Re: Basic % expression help

Fri, 08 Mar 2013 12:29:26 GMT

Hello Racine,

Please find attached qvw.

Please let me know if it was helpful, or anything else is required.

Thanks,

Angad

Re: Basic % expression help

Fri, 08 Mar 2013 12:33:55 GMT

Hello Racine,

If you cannot open the qlikview, then please find below explanation :

Write this in Script and then Reload

LOAD * INLINE [

Gender

MALE

FEMALE

];

Then right click on the sheet and create a chart(Straight Table) with following settings :

Dimension : Gender

Expression1 : =count(Gender)

Expression2 : =count(Gender)/count(TOTAL Gender), for the on the Number tab, select the Integer radio button and select Show in Percent checkbox.

Please let me know if this was helpful or anything else is required.

Thanks,

Angad

Re: Basic % expression help

Fri, 08 Mar 2013 14:20:21 GMT

Thank you very much for this and it does make sense. I've still got the problem that I want the % by another variable in a QlikView chart e.g. gender by year of entry, so that each year has the 100% broken down.

http://

Re: Basic % expression help

Fri, 08 Mar 2013 15:13:36 GMT

Hello Racine,

Can you please attach sample qvw with expected results. It might make things easier for me to understand.

Thanks,

itsangad

Re: Basic % expression help

Fri, 08 Mar 2013 15:46:21 GMT

I want a chart like this in QlikView:-

Re: Basic % expression help

Fri, 08 Mar 2013 18:11:09 GMT

Hello Racine,

Please find attached qvw.

Please let me know if it was helpful or anything else is required.

Thanks,

Angad

Re: Basic % expression help

Mon, 11 Mar 2013 09:21:32 GMT

Thanks a lot for this. It worked.

Regards,

Racine62