topic Re: Comments on Dimension in QlikView

Comments on Dimension

Anonymous — Mon, 31 Mar 2014 07:07:04 GMT

Dear All,

I have a layout issue with respect to Pivot Table. There's a customer requirement where "comments" are to be given on a Field Dimension - Bucket, as below:

16-45	Delayed (above 15 days)
8-15	Delayed (8 to 15 days)
2-7	Delayed (2 to 7 days)
0-1	will miss FFR in 1 days

On giving a random comment "abc" on Dimension, is displayed only over Dimension label.

Please assist in achieving this requirement.

Thanks,

Vijit

Re: Comments on Dimension

tresB — Mon, 31 Mar 2014 07:23:46 GMT

Try InputField .

Re: Comments on Dimension

its_anandrjs — Mon, 31 Mar 2014 07:29:31 GMT

If this bucket is created in load script then add a sequence it for that and in chart properties use that sequence id for sorting

Eg:-

Bucket SequenceId

0-1 will miss FFR in 1 days 1

2-7 Delayed (2 to 7 days) 2

8-15 Delayed (8 to 15 days) 3

16-45 Delayed (above 15 days) 4

Hope this helps

Thanks & Regards

Re: Comments on Dimension

Anonymous — Mon, 31 Mar 2014 07:46:07 GMT

Hi Anand,

How this will help in giving comments.

An Example to explain my requirement: If I roll mouse over the the Bukcet 16-45, "Delayed (above 15 Days)" as a comment must be diplayed.

Thanks,

Vijit

Re: Comments on Dimension

its_anandrjs — Mon, 31 Mar 2014 08:01:40 GMT

Create your flag like this

Eg:-

if(ID >= 0 and ID <= 3,'0-3-will miss FFR in 1 days',

if(ID >= 3 and ID <= 6,'3-6-Delayed (2 to 7 days)',

if(ID >= 6 and ID <= 8,'6-8-Delayed (8 to 15 days)'))) as Flag

and on chrt use subfield function like

=SubField(Flag,'-',3)

Then from 3 place you get commend script

Hope this helps

Thanks & Regards