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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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

4 Replies
sunny_talwar

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

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