Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Re: Re: weird requirement,please can someone help me out with this issue???????

Hi Bruno,

thanks a lot for the solution provided.

I have one doubt,now where can I place my 4 'if' statements??? because it has to take the market _value_1 which is coming from the code provided by you  instead of the old market value and the rest of the fields present in the expresssion   from data_.so how do I join these so that my buy call,sell call,buy put and sell put get calculated using the new market_value1 data ???????

please can you help in sorting out this????????????????

Highlighted
Not applicable

Re: weird requirement,please can someone help me out with this issue???????

Hi.

need help pl..??????????????

presently I am able to take up the new fields and calculate my buy_call expression in the front end table.But how do I finish this off in the script level itself????

Highlighted
Creator III
Creator III

Re: Re: weird requirement,please can someone help me out with this issue???????

Hi, sahana.

Here is another qvw with, I think, everything you want. Hope it helps.

Cheers.

Highlighted
Not applicable

Re: Re: Re: weird requirement,please can someone help me out with this issue???????

Hi Bruno,

Thanks for the solution provided.

I have tried to combine the 4 if statements into a single column as shown in the attached file,but the result is not the same.I am actually bad at nested if's .Can you please check the same and re-correct it please?????????????

and there is another exp a in the chart in sheet 3.Can we put this expression as a filter into the script itself??? I tried it but that time no data comes in the front end.can we do this????

Highlighted
Not applicable

Re: Re: Re: Re: weird requirement,please can someone help me out with this issue???????

hi,

As shown in the file attached the combined if statement in the script to match the values

buy/call

sell/call

buy/put

sell/put

according to their respective conditions.

please can you help?????????

Highlighted
Not applicable

Re: Re: Re: Re: weird requirement,please can someone help me out with this issue???????

I was able to resolve this ... thanks a lottttt for your help Bruno

Highlighted
Creator III
Creator III

Re: weird requirement,please can someone help me out with this issue???????

Hi, Sahana.

You're welcome. Sorry I was not able to get back to you earlier. I'm glad you managed to solve your problem.

Cheere!