topic Re: Add Expression dynamically in chart. in QlikView

Add Expression dynamically in chart.

agni_gold — Tue, 19 May 2015 06:35:17 GMT

Hi Friends ,

I have created the columns from values of fields and showed in the chart as expression. But if new values came in my field , then can it be automatically add to my expression .

Re: Add Expression dynamically in chart.

crusader_ — Tue, 19 May 2015 07:43:54 GMT

Hi,

Can you provide more details? If you provide your case with example, perhaps we can find any tricky solution.

Regards,

Andrei

Re: Add Expression dynamically in chart.

agni_gold — Tue, 19 May 2015 13:55:30 GMT

Name	Region	Value
A	India	10
B	US	20
C	US	30
D	UK	40
E	India	50
F	UK	60
Stright Table
Dimension	Expression1	Expression2	Expression3
Name	India	US	UK
A	10
B		20
C		30
D			40
E	50
F			60

Re: Add Expression dynamically in chart.

agni_gold — Tue, 19 May 2015 13:57:04 GMT

As you can see my source table structure is as , but I have make the Region values as columns . Now if any new region comes in my table the can it automatically added to my expression in straight table ?

Re: Add Expression dynamically in chart.

crusader_ — Tue, 19 May 2015 14:17:08 GMT

Hm... If expression 1,2,3 are equal... and we just change the region, than we can move second dimension to horizontal axis....

Check my example whether it acceptable?

Regards,

Andrei

Re: Add Expression dynamically in chart.

agni_gold — Tue, 19 May 2015 14:25:56 GMT

no what I am saying is that , iam only showing the below table in qlikview , and if in my source , a new value suppose Australia came , so can it be automatically added to my expression , because here India , US , UK are expression and Name is dimension.

Name	India	US	UK
A	10
B		20
C		30
D			40
E	50
F			60

Re: Add Expression dynamically in chart.

crusader_ — Tue, 19 May 2015 14:40:23 GMT

Wait... In my example I added Germany to my dataset and it appears as column... You can add some new strings and will see that columns add and hide (if delete some rows)...

Expression always should be defined... So if you do not apply different calculation logic to every new expression, there is no reason to make 2,3,5 or more expressions... But if you're going to apply different formula for every new region this chart definitely requires maintenance...

Hope this helps you.

Regards,

Andrei

Re: Add Expression dynamically in chart.

agni_gold — Tue, 19 May 2015 19:10:43 GMT

Yes u r right , but i have multiple expressions , so when i want to do like you it changes all the expressions .

Your way is not possible.

Is there any other way , actually i have done with generic load , but i am facing the issue , what i have originally asked.

Re: Add Expression dynamically in chart.

MarcoWedel — Tue, 19 May 2015 20:20:20 GMT

‌hi,

you could use a pivot table instead of a straight table.

regards

Marco

Re: Add Expression dynamically in chart.

crusader_ — Wed, 20 May 2015 05:43:15 GMT

Hmm.. Generic LOAD can add new fields to your original data set according to the values in some column,

but definitely will not help with charts...

In this case you could try create object via macro or define your chart on variables like was suggested here Re: Create a chart via the load script

Hope this helps.

Regards,

Andrei