Filter pane and Pivot Table functionality with different measures

[Dhruva1]

I have requirement in Qlikview  like this below.

i have one filter 'Status'. below this i have one vendor table with 5 measures . please look at the screenshot.

if i select the "status "filter as "approved" then in the pivot i want to see like Measure1,Measure2,Measure3.

if i select the "status" filter as "approved, Pending" then in the pivot i want to see like Measure1,Measure2,Measure3,Measure4.

if i select "status" as "all" then i want to see the entire pivot with all columns. if i didn't select anything in the status filter still i want to see pivot with all the measures.

[Or · Accepted solution]

You can use conditions for each measure regarding when to display it.

Typically this would be something like:

WildMatch(concat(FieldName),'*Value1*','*Value2*')

[Dhruva1]

I will try the above expression .

This one want to implement on qlikview.

[Or · Accepted solution]

Sorry, missed the QV part. Same expression, just different place to put it.

[Dhruva1]

Substringcount(concat(getfieldselections(fieldname)))

This is working for me for the selections but default without any selections in the filter I want to see all the measures in the pivot. Any suggestions?

[Or · Accepted solution]

Use concat as I suggested, not getfieldselections.

[Dhruva1]

Using concat as you suggested is working . And satisfies my requirement.

Thanks alot