topic Syntax for alternate state with conditions in QlikView

Syntax for alternate state with conditions

Tue, 27 Jan 2015 17:04:23 GMT

Hello,

I need to do a distinct count on Seq# when Payer Type = 'T' for State1 and State2. Here is what I'm using...

=Count({State2}{$<[Payer Type]={T}>} DISTINCT([Seq#]))

From what I can tell this formula renders all states, not just State2. Do I have my syntax incorrect?

Please let me know.

Thanks so much.

rwunderlich — Tue, 27 Jan 2015 17:09:35 GMT

You have too many braces. Should be:

Count({State2<[Payer Type]={T}>} DISTINCT([Seq#]))

-Rob

Tue, 27 Jan 2015 17:15:27 GMT

It looks like it changes by state now but when I select other filters it's disregarding them. So here's what I now have...

=Count({State2<[Payer Type]={T}>} DISTINCT([Seq#]))

Do I need to add $ somewhere to ensure the inherited filters apply?

rwunderlich — Tue, 27 Jan 2015 17:30:55 GMT

I think it's back to your original syntax but with "*" between the sets:

=Count({State2 * $<[Payer Type]={T}>} DISTINCT([Seq#]))

Note corrected syntax.

Tue, 27 Jan 2015 17:35:47 GMT

I tweaked what you had a little and I think this is it. Just in case anyone reads this here is the final winning combo!

=Count({State2 * $<[Payer Type]={T}>} DISTINCT([Seq#]))

Rob - thank you so much. It's so nice to be able to bounce these dilemma's off others:) Much appreciated.

rwunderlich — Tue, 27 Jan 2015 17:40:00 GMT

Glad to help. Don't forget to mark something (including your own response ) as correct to close the thread.

-Rob

Thu, 29 Jan 2015 02:38:44 GMT

Rob - how would this formula look if I didn't need to define payer type = T but wanted all filters not in State2 to apply?