topic Re: Passing all values from a field in Match() function in QlikView

Passing all values from a field in Match() function

rsdhavle — Tue, 26 Jul 2016 07:13:39 GMT

We have a requirement where we want to pass all values from one field in match function so that we can only show grand total column in a table. can we pass all values in match function together or we have to explicitly mention each value

Re: Passing all values from a field in Match() function

PrashantSangle — Tue, 26 Jul 2016 07:20:24 GMT

Not getting what are you trying to do??

can you elaborate little bit more. Where you want to do this execution.

check exist(), Total in front end.

Regards

Re: Passing all values from a field in Match() function

marcus_sommer — Tue, 26 Jul 2016 07:21:37 GMT

Please provide more details, for example a few sample data and the result which you expect.

- Marcus

Re: Passing all values from a field in Match() function

saimahasan — Tue, 26 Jul 2016 07:25:18 GMT

If you want to have only grand total column in table, why are you using table?? you can have it in textbox also

Re: Passing all values from a field in Match() function

rsdhavle — Tue, 26 Jul 2016 07:28:14 GMT

I have one field name client and we are calculating certain expression in one table on this dimension however this table has restricted data.

I just need to place one more table beside this in exact same format as original table which will only show Grand Total column so i am trying to make a copy of same table and using a match function just making other columns null and keeping grand total column.

I just want to know lets say FieldA contains 1,2,3..1000 values. Do i need to mention all these values explicitly in match function condition or there is any way i can just compare all values together in match function

Re: Passing all values from a field in Match() function

marcus_sommer — Tue, 26 Jul 2016 07:33:10 GMT

I don't think that you will need the match-function else something like:

sum(TOTAL value) // without or ignoring all dimensions

sum(TOTAL <YourMainDimension> value) // considering one or more dimensions

- Marcus

Re: Passing all values from a field in Match() function

rsdhavle — Tue, 26 Jul 2016 07:34:54 GMT

How can i hide dimension column in this case? as i need to only show grand total column

Re: Passing all values from a field in Match() function

marcus_sommer — Tue, 26 Jul 2016 07:39:50 GMT

I don't think that you need to hide the detail-dimensions else just simply remove them from these table.

- Marcus