topic Re: how to get selected values using match function in QlikView

how to get selected values using match function

ravindraa — Thu, 05 Mar 2015 09:15:38 GMT

Hi all,

I have struck one place please give me any suggesion to come out from this.

my requierment is , i have one field that is DocId there are many DocId is there but i want only some DocID only for that i ahave used Match Fuction in Dimension to get requied DocId values, but along with requiered DocId values remaing values also coming as Null value , actuvaly i want remove the Null Values.

I can do the suppress null value check box but if i do that the sum of the sales is displaying as total value.

please give me any suggesion on this.

Please find the attached doc.

Thanks in advance.

Re: how to get selected values using match function

Gysbert_Wassenaar — Thu, 05 Mar 2015 09:20:43 GMT

Try using DocID as dimension and as expression =sum({<DocID={110,111,112}>}Sales)

Re: how to get selected values using match function

ravindraa — Thu, 05 Mar 2015 09:41:11 GMT

Hi Gysbert Wassenaar,

Thanks for replying ,but is there any way to get selected values in dimension it selt only , becase for one dimension it is ok but i have more than 5 dimension's.

Please give me any suggession.

thanks in advacne.

Re: how to get selected values using match function

Gysbert_Wassenaar — Thu, 05 Mar 2015 09:49:27 GMT

It hardly matters if you hardcode values in calculated dimensions or in expressions. If you want less work you make the selections first, then create a bookmark for those fixed selections. Then you can use the bookmark in the expression: sum( {BookMarkNameHere} Sales)

Re: how to get selected values using match function

ravindraa — Thu, 05 Mar 2015 10:01:02 GMT

Hi Gysbert Wassenaar,

thank you very much for replying could you please share how to get this using caliculated Dim,

thanks in advance