topic Text object: formula in QlikView

Text object: formula

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I was trying to create a text object in order to show complaints for 2016 and by phone.

to do that in text i write this:

=Num(count({<DateReceivedYear={"2016"} and SubmittedViaName={"Phone"}>}ComplaintId), '#,##0', '.' , ',' )

but it turns out an error.

If I only write one condiction it works but as this case is of two conditions it does not works (I don't know if the ommand "and" is right etc)

Could you help me please?

Thanks

Digvijay_Singh — Sat, 10 Mar 2018 17:46:25 GMT

try this -

=Num(count({<DateReceivedYear={2016},SubmittedViaName={"Phone"}>}ComplaintId), '#,##0', '.' , ',' )

Digvijay_Singh — Sat, 10 Mar 2018 17:47:35 GMT

Use single quote for literals -

=Num(count({<DateReceivedYear={2016},SubmittedViaName={'Phone'}>}ComplaintId), '#,##0', '.' , ',' )

Anonymous — Sat, 10 Mar 2018 18:55:24 GMT

Perfect,

You are a master!!

Thanks a lot