field

[Qlik1_User1]

Hi,

I am using and i have a field as Ryr which is numeric (checked via isnum() as well) but when I am searching in  its not interpreting it .. please suggest what is missing..

This is the data i am using, when i am searching a simple query like "premium for year" its giving below result, which is incorrect ,pls help


LOAD * INLINE
[
Client,RYear,Premium
A, 2019, 100
A, 2020, 200
B, 2021, 300
B, 2022, 400
B, 2023, 500
C, 2019, 600
C, 2020, 700
D, 2024, 800
D, 2025, 900
E, 2020, 1000
];

@hugo_andrade  @igoralcantara @marksouzacosta @marcus_sommer 

[Qlik1_User1]

@kiseke8485 Please click on the image it will open up.

[Qlik1_User1]

Hi @kiseke8485 

This is the data i am using, when i am searching a simple query like "Show premium for year 2023" its giving below result, which is incorrect ,pls help
NOTE: Using HUB level IA chat bot.

Vocabulary

Logical Model

LOAD * INLINE
[
Client,RYear,Premium
A, 2019, 100
A, 2020, 200
B, 2021, 300
B, 2022, 400
B, 2023, 500
C, 2019, 600
C, 2020, 700
D, 2024, 800
D, 2025, 900
E, 2020, 1000
];

[marcus_sommer]

Never worked with this tool but the reason might be that Year <> RYear respectively the call has no valid references to the data.

[Qlik1_User1]

@marcus_sommer Thanks, in Vocabulary we have mentioned the synonym for Ryear as Year which will solve that issue but still its not working.

[marcus_sommer]

Qlik acts case-sensitive - therefore check how the fields are really written because: Ryear <> RYear (like named in the inline-load).

[hugo_andrade]

Hi @Qlik1_User1,

Let's go step by step.

Are you able to get the Insight Advisor, ask to Show apps and see the app in question?

Let's troubleshoot step by step?

[Qlik1_User1]

@hugo_andrade Yes I am able to get the app name.

[Amit_Prajapati]

Hi, In logical model mention classification as dimension instant of year and try !

[Qlik1_User1]

@Amit_Prajapati Tried that as well but that too didn't work