topic Expression in Straight Table in QlikView

Expression in Straight Table

bharatkishore — Thu, 17 Aug 2017 11:48:06 GMT

Hi All,

I have 10 fields in a list box by writing an load * inline statement. I have written the below expression in the straight table chart

=sum(IB_1)

Now my problem is,this expression should be changed whenever i select a field(Flag) the expression should be changed to sum(IB).

If i un-select flag then it should be changed to sum(IB_1).

Attached qvw for reference.

Is it possible to achieve.

Thanks,

Bharat

Re: Expression in Straight Table

sunny_talwar — Thu, 17 Aug 2017 11:52:42 GMT

May be this

Re: Expression in Straight Table

mayankraoka — Thu, 17 Aug 2017 11:59:18 GMT

Hi Bharat,

If I understand your requirement correctly here is the solution.

Please find attached qvw

Regards,

Mayank !

Re: Expression in Straight Table

bharatkishore — Thu, 17 Aug 2017 12:48:04 GMT

Thanks Sunny....You are just Awesome...

One more thing after writing this expression based on the month selection the value should effect.

For example: if i select jan the value should be (expression)/1 , if i select feb (expression)/2 , if i select march (expression)/3 if i april (expression)/4.. Can you please tell me how to achieve this..

Re: Expression in Straight Table

sunny_talwar — Thu, 17 Aug 2017 13:13:47 GMT

May be this

Re: Expression in Straight Table

bharatkishore — Thu, 17 Aug 2017 13:21:02 GMT

Thanks Genius.. Sorry Missed the trick..