topic Re: Guage, expression, two tables! in QlikView

Guage, expression, two tables!

Wed, 09 Dec 2015 11:57:06 GMT

Please can someone help me with the attached example.

I have two tables on the attached:

CONCERNS and TRANSACTIONS.

I would like to create TWO guages - one for the current month and one for the previous

month which show the percentage of concerns.

To work out the no of the concerns I need to do a count on concernID

To work out the transcations do a count on the pick column where it is '1'

So for example - current month

needs to be count of concernID / Count of Pick * 100 BUT only for the current month ?

can someone help me achieve this?

I also do not want to fix it so that I can select on plant that only appears in the transactions table !!

Thank you

Anonymous — Wed, 09 Dec 2015 12:00:58 GMT

their is only one table which is Concern only

Anonymous — Wed, 09 Dec 2015 12:05:33 GMT

try like this:

CurrentMonth:

=(Count({<MonthField=,Year=,MonthField={'$(=max(month(DateField)))'}>} concernID )

Count({<MonthField=,Year=,MonthField={'$(=max(month(DateField)))'}, PickField={'1'}>} concernID or PickID))*100

Previous Month:

=(Count({<MonthField=,Year=,MonthField={'$(=max(month(DateField))-1)'}>} concernID )

Count({<MonthField=,Year=,MonthField={'$(=max(month(DateField))-1)'}, PickField={'1'}>} concernID or PickID))*100

Wed, 09 Dec 2015 12:28:33 GMT

Oops! Added

Anonymous — Wed, 09 Dec 2015 12:30:15 GMT

NP, you can try expression shared with you earlier

Anonymous — Wed, 09 Dec 2015 12:33:41 GMT

Again, how these two tables are linked as their is no mapping of these two tables?