need help

[NavinReddy]

Dear Experts,

Is there any way can i make one function for list of discriptions in Qlikview. i tried with pivot table.

Please find the below imagae look like i want to impliment in Qlikview.

please suggest me if any ideas

Thanks in Advance,

Niranjan

[Clever_Anjos · Accepted solution]

as long as I can see it´s not possible using a regular pivot table

A similar solution could be

• Convert BenchMark into dimension
• Convert "Target Limit" into dimension
• Remove EID dimension
• Use "Ident mode" under Style tab

[neelamsaroha157]

Are you looking for something like this.

[NavinReddy]

Thank you so much Clever so how i can manage with this solution

[NavinReddy]

Hi Clever,

For all functions its displaying subtotals. Can you please suggest me how could we disable subtotal for function.

Thanks in advance

Niranjan