topic Data not reflecting in QlikView

Data not reflecting

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

Hello Developers

I have 1 month data in my app and recently i have added another 12 months data. i am using 8 variables to get the output. previously the variable expression is like this;

=Max({<BillingRegionType = {"INTL"}>}max_territory_cnt-1month)

now i have added 12 months data and created the variable like

= If(ToggleSort=1,max({<BillingRegionType = {"IVF"}>}max_territory_cnt_1_month),max({<BillingRegionType = {"IVF"}>}max_territory_cnt_12_month))

i created an inline load to create a field called togglesort the values for 1 montn is 1 and 12 months is 2. But when i select the 12 month from the field the data is not changing. can any one help me please?

Thanks

Anil Danda

Re: Data not reflecting

sunny_talwar — Thu, 06 Oct 2016 22:48:45 GMT

Would you be able to share your qvw or a sample so that we can see the issue?

Re: Data not reflecting

dandaanilreddy — Thu, 06 Oct 2016 23:23:11 GMT

Thanks for the reply Bro. I had shared the app.

Thanks

Anil Danda

Re: Data not reflecting

trdandamudi — Fri, 07 Oct 2016 01:19:22 GMT

I still don't see the attachment....

Re: Data not reflecting

Anil_Babu_Samineni — Fri, 07 Oct 2016 07:28:09 GMT

NP, Just load simple all months using either concatenate / Join then tell me what you want to achieve from this expression. Would you provide few scramble data and target image