All variables don't show up in my Qliksense dashboard

[chaitakc]

Hi Qlik community,

I am new user to Qliksense. I am using Qliksense desktop dash board in my office. I am using ODBC connection and extracting data from MySQL. I am currently running an sql query for different regions in world. I could see the details of the 16 regions like EMEA, north america etc; in my mysql query. However when i use the same query at data load editor end ,i could see only values of 15 regions not 16 in the Qliksense dashboard. What could be the potential problem for 16th region not showing up in my Qliksense dash board? The 16th region is mapped in the qliksense end.

Thanks.

[shraddha_g]

Share sample app else screenshot of query you used.

[chaitakc]

[chaitakc]

The plant code consists of the regions that i am trying to extract ie. all the 16 regions. The 16th region is included in the plant code.

[Anonymous]

Hi there

What do you see if you create a simple table object on a new sheet and drag and drop the  [Plant Code] field on to the table; nothing else.

1. Do you see 15 or 16 regions in the table
2. Are any grayed out

Neil

[chaitakc]

Hi Neil

When i create a new sheet with only plant code, the 16th region does appear.

Thanks

[Anonymous]

So you said in your original post...

However when i use the same query at data load editor end ,i could see only values of 15 regions not 16 in the Qliksense dashboard. What could be the potential problem for 16th region not showing up in my Qliksense dash board?

How are you showing your regions in your dashboard. What object are you using and what is expression?

Neil

[chaitakc]

I have shared some screenshots of dashboard. Details have been masked

[chaitakc]

the dimensions tab consists of all the variables however AP_India doesn't appear as stated in the above picture

[chaitakc]

When i filter down to AP_india below are the details I get from dash board. However when i run the same query in my sql I get data for AP_india