Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
dandaanilreddy
Partner - Creator III
Partner - Creator III

Data not reflecting

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

Labels (1)
4 Replies
sunny_talwar
MVP
MVP

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

dandaanilreddy
Partner - Creator III
Partner - Creator III
Author

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

Thanks

Anil Danda

trdandamudi
Master II
Master II

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

Anil_Babu_Samineni
MVP
MVP

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful