topic Re: Creating relation between expression and new column in QlikView

Creating relation between expression and new column

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

Hi all,

I have very complicated requirement.I have to link expression in bar chart RR1 ,RR2,RR3 with newly excel data column MAASP[bar].

Please find the snapshot and data and please help me .

Regards

Manu

Re: Creating relation between expression and new column

Digvijay_Singh — Mon, 09 Apr 2018 15:35:43 GMT

Can you share expected output, difficult to understand what do you need exactly.

Re: Creating relation between expression and new column

manu1512 — Mon, 09 Apr 2018 15:43:14 GMT

Hi Digvijay ,

RR1 RR2 RR3 are expressions in chart while in excel sheet they have corresponding MAASP bar values in excel sheet .In bar chart we want to show MASSP BAR values to corresponding RR1 RR2 RR3 values.

Regards

Manu

Re: Creating relation between expression and new column

Digvijay_Singh — Mon, 09 Apr 2018 15:54:21 GMT

Not sure but, something like this in RR1,RR2..expressions -

1. RR1 - Sum({<Ringraum = {'RR1'}>}MAASP)

similarly for RR2, and RR3

Not sure if Other category Bohrung has any significance here or not.

Re: Creating relation between expression and new column

manu1512 — Mon, 09 Apr 2018 16:06:13 GMT

Hi Digvijay,

Bohrung has very huge significance as every bohrung has correspondingRR1/RR2/RR3 and every RR1/RR2/RR3 for Bohrung has Maasp values.

Regards

MANU

Re: Creating relation between expression and new column

Digvijay_Singh — Mon, 09 Apr 2018 16:11:31 GMT

Yes, so Bohrung is your bar chart dimension?

Re: Creating relation between expression and new column

manu1512 — Mon, 09 Apr 2018 16:16:09 GMT

No Bohrung will be used as key filter.

Re: Creating relation between expression and new column

manu1512 — Mon, 09 Apr 2018 16:45:05 GMT

stalwar1‌kaushik.solanki‌

Re: Creating relation between expression and new column

sunny_talwar — Mon, 09 Apr 2018 16:52:46 GMT

You have created this chart (image above) using the three fields that you provided in the sample? 1) I am not sure if I be able to replicate the chart and if I did how much time would I be spending to replicate it ... 2) I am not really sure what is that you are looking to fix... can you make my life easier by creating a dashboard with the data loaded and the chart created in a sample qvw and then letting us know what is the problem that you are trying to fix

Re: Creating relation between expression and new column

manu1512 — Tue, 10 Apr 2018 11:41:15 GMT

Hi all thanks for help, by just doing minor change in data source i got my answer.

Thanks for your help

Regards

Manu