topic Re: Condition in Set doesn´t work in QlikView

Condition in Set doesn´t work

Thu, 12 Mar 2015 10:47:16 GMT

Hello,

I have these two calculations in a chart, see below.

Why is also values lower than 3000000 counted ?

=Sum{$<$(vSetPreviousMonth),Segment={"Glas"}>} [DebPris] ) for raw

=Count({$<$(vSetPreviousMonth),Segment={"Glas"},[KundNr]={"=Sum([DebPris]) > 3000000"} >} [KundNr]) for Prev mon sum>

kindly

Håkan

Re: Condition in Set doesn´t work

Gysbert_Wassenaar — Thu, 12 Mar 2015 10:53:09 GMT

Probably because the sum in =Sum([DebPris]) > 3000000"} > doesn't have the same set modifiers.

Try:

=Count({$<$(vSetPreviousMonth),Segment={"Glas"},[KundNr]={"=Sum({<$(vSetPreviousMonth),Segment={"Glas"}>}[DebPris]) > 3000000"} >} [KundNr])

Re: Condition in Set doesn´t work

Thu, 12 Mar 2015 11:33:22 GMT

Hello again,

I tried this but now is there no answer at all, I only get - in all cells.

I added an test app for this.

Håkan

Re: Condition in Set doesn´t work

Fri, 13 Mar 2015 11:18:19 GMT

Hello,

I solved the problem with help from Gysbert, but I had to change the " to ' or [ in the dimension.

I cannot find out the difference between these three ways to do it.

kindly

Håkan

Re: Condition in Set doesn´t work

Gysbert_Wassenaar — Fri, 13 Mar 2015 11:51:29 GMT

Ah, yeah. Blindly copy-pasting again. The problem was that there were nested "" pairs. So one of the pair had to be changed to single quotes or a pair of square braces or back ticks ```.