topic Re: Getting Data with selectValues() in Integration, Extension & APIs

Getting Data with selectValues()

HarshPrajapati — Tue, 12 Sep 2023 10:35:29 GMT

Hello guys , I am facing one issue. I am getting data with below expression

app.field('title').selectValues(selectedValues, true, true)

But while data with the selectedValues is not found it returns whole data about that field. Is there any way to prevent this??

Also I have one question , Is there any method in Qlik that provides data checking like for example, data with a selected combination of data fields and filter is available or not like they did here :- https://bivisual.cpa.texas.gov/CPA/opendocnotoolbar.htm?document=documents%5CTR_Master_UI.qvw

here they are showing disable like checkbox is data is not available about that filter and I want to do something like that.

Re: Getting Data with selectValues()

alex_colombo — Fri, 15 Sep 2023 14:38:33 GMT

Hi @HarshPrajapati , why are you using selectValues method for getting data from a field? Could you please explain what is your goal? selectValues method is useful for select values in a field.
About second question, I think you have to monitor current selections and understand which values are selected, am I right?

Re: Getting Data with selectValues()

HarshPrajapati — Mon, 18 Sep 2023 03:30:07 GMT

I am trying to build a website like I mentioned in my question, so I need fields that user selects, but there is one issue when we use selecteValue with the data we want, it returns specific data if available else it sends the whole data of the column. I need to disable the checkboxes if data is unavailable like they did on a website.

https://bivisual.cpa.texas.gov/CPA/opendocnotoolbar.htm?document=documents%5CTR_Master_UI.qvw

Re: Getting Data with selectValues()

alex_colombo — Mon, 18 Sep 2023 13:14:18 GMT

If you want to know which fields have been selected by users, you have to use selectionState method.
Instead, for reading all the data with the information if a value is selected, optional, excluced, etc.. from a field, you have to create a ListBox for each selected fields. You can follow these steps for creating it.
With this information, you know which data are selected, which data are exceluded, then you can disable data for your checkboxes

Re: Getting Data with selectValues()

HarshPrajapati — Wed, 20 Sep 2023 10:45:58 GMT

Am doing the same, I am checking which field is selected by a user and after that according to those values am building a chart. My main concern is if I have 3-4 types of filters like year, company, country, and salary. I have selected the year 2017, suppose there are some country there is not any data. so is there any way from that I can check if a user selects a value in one filter, there is any value available on the data? if yes then it should be selectable and if not then I want to disable them.

Re: Getting Data with selectValues()

alex_colombo — Thu, 21 Sep 2023 06:47:33 GMT

As I mentioned, when you create a ListObject on a specific field, you can read all the data, and for each value you can understand if this value is available, excluded, optional, selected and so on. With this you can disable them based on your requirements. Please try to create a ListObject and when you get the data, you have qState parameter that indicated you the current state (selected, excluded, optional, etc)

Re: Getting Data with selectValues()

HarshPrajapati — Thu, 21 Sep 2023 10:54:37 GMT

Okay , Thank you just one last question, Am getting qState as 'O' and 'X' what does it means??

Re: Getting Data with selectValues()

alex_colombo — Thu, 21 Sep 2023 11:56:20 GMT

Have a look here, there are descriptions for all possible values for qState.

Re: Getting Data with selectValues()

HarshPrajapati — Fri, 22 Sep 2023 03:04:43 GMT

Ok thank you.