topic Re: Data is not getting populated in QlikView

Data is not getting populated

abc_18 — Mon, 04 Oct 2021 11:50:16 GMT

Hi ,

I am using below expression in a text box and it's returning 0 values, but if I remove '$' sign I can see the data

=count({<builddate={"$(=date(max(builddate)))"},comp={'Compliant'}>}distinct [comp Id])

Please suggest what I am missing

Regards

AshutoshBhumkar — Mon, 04 Oct 2021 11:59:50 GMT

Hello,

Check for the date format of builddate.

Can you please show what is being calculated in the expression editor.

abc_18 — Mon, 04 Oct 2021 12:14:27 GMT

Hi Ashutosh,

My date is set to below format, and builddate is also displaying in same format only.

SET DateFormat='M/D/YYYY';

And this field I am directly using from table without any changes.

AshutoshBhumkar — Mon, 04 Oct 2021 12:20:53 GMT

Ok. Could you please provide a screenshot of expression editor ?

Need to check what is being calculated in the editor.

abc_18 — Mon, 04 Oct 2021 12:40:03 GMT

Hi, above is the screenshot.

AshutoshBhumkar — Mon, 04 Oct 2021 12:48:04 GMT

Try assigning date format to to the Date used in Set analysis.

=count({<builddate={"$(=date(max(builddate),'M/D/YYYY'))"},comp={'Compliant'}>}distinct [comp Id])

abc_18 — Mon, 04 Oct 2021 13:18:43 GMT

Thanks it's working now.

I have a doubt, before without providing date format it was working fine.

Today I started getting issue and after removing of '$' I am Getting the result.

AshutoshBhumkar — Mon, 04 Oct 2021 14:19:01 GMT

Okay. Must be any data format change from backend.

abc_18 — Tue, 05 Oct 2021 03:59:41 GMT

Thanks Ashutosh, will check that, thanks.

But after removing '$' I can see the data, still need to be validate whether it's correct or not..

is it because of '$' returns current selection and whatever is applicable it's just displaying??

AshutoshBhumkar — Tue, 05 Oct 2021 04:38:13 GMT

Yes, It states all records in current selection.