topic Re: Call a Variable in Label!!!!!! in QlikView

Call a Variable in Label!!!!!!

Tue, 06 May 2014 06:14:13 GMT

HI All,

I want a cal variable in my label but the thing is my label is Dynamically changes how u can create for that one

can u plzzzzz help me

Thanks

Tue, 06 May 2014 06:18:00 GMT

your requirement is not clear. can you explain a bit more possibly with some data?

jagan — Tue, 06 May 2014 06:19:36 GMT

Hi,

In label text box just give

=variableName

=$(variableName)

This will work, if this is not you are expecting then come up with an example.

Regards,

Jagan.

Tue, 06 May 2014 06:35:59 GMT

DIm

label

cvi_remarks

remarks

startdate

date

IVRDURATION

Duration

see I have Dim And Label when am using cvi_remarks i want show the label remarks only like. that...............

i don't want hard code by using the variable it self we can do

How it is?

jagan — Tue, 06 May 2014 06:41:20 GMT

Hi,

Can you attach some sample file, it helps to give solution quickly. How you are using the Dimension? Are you using any Cyclic or drill down group?

Try this expression

=Only({<DIm={'startdate'}>} DIm) this will give you date as label, if you have table with DIm and label columns.

Regards,

Jagan.

nirav_bhimani — Tue, 06 May 2014 07:04:59 GMT

HI ,

If you have limited dimension then you can use the if startement for that

Eg.

If((Dim='cvi_remarks','remarks',Dim='startdate', 'date',Dim='IVRDURTION','Duration' )

Regards,

Nirav Bhimani