topic Re: How to show expected data without any selection also? in QlikView

How to show expected data without any selection also?

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

Hello All,

I'm really not sure how to achive this, like refer the screenshots in attachment.

in image DATA there are no selections made on any field which shows wrong values but refer the other image of selection data, after selecting a value from any column the result in payment and Cust_Balance Column will become correct values

But without any selection made the values will be different in Balance and Payment column opposite to that selected value

So with and without filtering row values the data Opposite to every row value should be correct

Please assist.

Thanks

Re: How to show expected data without any selection also?

sasikanth — Wed, 19 Dec 2018 10:03:48 GMT

HI,

please post expressions used for Payment & cust_balance .

and please share your app if possible

Thanks,

sasi

Re: How to show expected data without any selection also?

tahreen371 — Wed, 19 Dec 2018 10:23:20 GMT

Hello sasi,

App is attached, please help on this.
Thanks in advance

Re: How to show expected data without any selection also?

Anil_Babu_Samineni — Thu, 20 Dec 2018 04:05:18 GMT

Thanks for your example, Which column we need to look and where and what is expected one?

Re: How to show expected data without any selection also?

tahreen371 — Thu, 20 Dec 2018 04:34:07 GMT

hello, That issue is resolved as i applied Set analysis but i'm facing another problem

when I'm validating my data with expression Total vs Sum Total in straight table, the Balance and Cust.Balance total differs

Please suggest