topic Re: Set Analysis - putting together two expressions in QlikView

Set Analysis - putting together two expressions

Fri, 04 Jan 2013 11:43:36 GMT

Hi,

I want to marry together two different pieces of set analysis which both work indidually in two seperate charts.

count({<~[>5mins]='Y'>}DISTINCT [%Interaction Id])

count({<$*'StateA'}DISTINCT([%Interaction Id]))

I want both of these expressions to apply to a new chart that I am building.

Your help would be greatly appreciated

Thanks

khadeer — Fri, 04 Jan 2013 11:53:03 GMT

how u want to merge side by side or one after other.

Fri, 04 Jan 2013 14:06:20 GMT

Which would you advise?

I just need my chart to plot both criteria in the same expression

chematos — Fri, 04 Jan 2013 18:17:30 GMT

count({<~[>5mins]='Y'> and <$*'StateA'}> }DISTINCT [%Interaction Id])