topic Re: Use Record data in set expression in App Development

Use Record data in set expression

JeroenHoltrop — Mon, 07 Feb 2022 09:58:09 GMT

Hi all,

I hope you can help me, as i tried finding the way to do this, but I am not getting there.

This gives me the result I want:

only ({$<PropositionComponentKey={'12'}, PricePropositionStartDateKey={"<=20210101"}, PricePropositionEndDateKey = {">=20210201"} >}Price)

The dates should be updated by record data, so the dates are coming from the record in Qliksense. I cannot seem to get the correct command for it. This seems logical to me, but Qlik thinks differently 🤔

only({$<PropositionComponentKey={'12'}, PricePropositionStartDateKey={"<={$(=InvoiceLineStartDateKey)}"}, PricePropositionEndDateKey = {">=20210201"} >}Price)

The invoicelineStartDateKey is exactly the data that is in the first query, however the result in my Qliksense screen is a null value. I have tried multiple ways to have the daya in my query, but the result currently is always the same.

Is there anyone who knows what I do wrong?

Re: Use Record data in set expression

hic — Mon, 07 Feb 2022 14:14:00 GMT

You have one pair of curly brackets too many.

... ={"<={$(=InvoiceLineStartDateKey)}"}, ...

should be

... ={"<=$(=InvoiceLineStartDateKey)"}, ...

Re: Use Record data in set expression

rubenmarin — Mon, 07 Feb 2022 14:18:22 GMT

Hi, you can a field list to check the available values for InvoiceLineStartDateKey, if there is more than one possible value the expression will fail.

Note that set analysis is not evaluated row by row, it is calculated before the table to select the dataset, and after that the chart is calculated using this dataset.

Also this can be a format issue, is the value for InvoiceLineStartDateKey in YYYYMMDD format?

If you open expression editor you can check a the bottom how $(=InvoiceLineStartDateKey) is converted to see the expanded expression that will be used.

Re: Use Record data in set expression

JeroenHoltrop — Mon, 07 Feb 2022 15:17:16 GMT

Yeah, that is it, now it works, thank you very much @hic !