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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
julioarriaga
Creator II
Creator II

Valuelist is not working on nested ifs?

Hi everyone, I'm trying a nested if with a value list but it doesn't shows the last record although it shows my syntax is correct (I tried the same thing with the commented code and it worked).

Thanks in advance for the help.

Capture1.PNG

Capture2.PNG

Capture3.PNG

1 Solution

Accepted Solutions
julioarriaga
Creator II
Creator II
Author

I just saw what the error was. The format in the dates was in mm/dd instead of dd/mm.

View solution in original post

3 Replies
devarasu07
Master II
Master II

Hi,

Expression looks fine. do u have data for 201703 period?  would be able to share the mock data. tks

Anil_Babu_Samineni

Try the Third one in text object and check because ValueList() is only for Static displaying not the dynamic one. And mean do suppress when value is null option then check?

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
julioarriaga
Creator II
Creator II
Author

I just saw what the error was. The format in the dates was in mm/dd instead of dd/mm.