topic Re: Label issue in QlikView

Label issue

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

Dear Sir/Madam

I have faced two problems stated below, please help :

1. Can not get Year from Date?

2. Label E cannot be shown after selecting both A & E Class?

Thank you

Tracy

Re: Label issue

devarasu07 — Tue, 09 Jan 2018 01:30:25 GMT

1) Can not get Year from Date?

use like below

=Year(Date(Num#(Date),'DD-MM-YYYY'))

also note if your going to use this year field in many chart object then use this code in back end one time and can reuse multiple chart.

2) Label E cannot be shown after selecting both A & E Class?

refer to the attachment.

just add Class Dimension and create a measure as avg(Data) then u can get the desired output. thanks

Re: Label issue

tracycrown — Tue, 09 Jan 2018 01:55:10 GMT

Dear Devarasu R

Thank you for your help, can you advise how to present both A & E in Scatter Chart for just a year ?.

Thank you

Tracy

Re: Label issue

devarasu07 — Tue, 09 Jan 2018 02:11:44 GMT

Hi,

yes. you need to have min 2 measures for the scatter chart.

let say u can have sum(Data) and avg(Data)

Recipe for a Scatter Chart

Re: Label issue

tracycrown — Wed, 10 Jan 2018 00:38:35 GMT

Dear Devarasu R

Many thanks for your kindness to share an article on scatter chart and detailed illustration, well done.

I would like to go one step further, please advise how to present average data for Type on Y-axis and Class on X-axis in particular year using Scatter Chart ?

Cheer

Tracy

Re: Label issue

tracycrown — Wed, 10 Jan 2018 00:47:40 GMT

Dear Devarasu R

Attached is a sample extracted from www.360globalconsulting.com which is similar to what I requested in previous reply to you.

Thank you

Tracy