topic Re: Dimension Limits Issue in QlikView

Dimension Limits Issue

Mon, 22 Jul 2013 15:58:42 GMT

Hi All,

I Need to show Least 5 perfoming clients by Actaul Revenue. and others and totals

I should not show clients which have '0' Values in Actual Revenue or Planned Revenue

when i try to do this i get '0' Vales in Actual Revunue

But My output should look Like this

Please find attached source file (Data is in Sheet1)

Apprecite help on this

Mon, 22 Jul 2013 16:45:33 GMT

Hi,

Did you try to put the condition like if(YTD Planned Revenue > 0, YTD Planned Revenue) in your expression?

Gysbert_Wassenaar — Mon, 22 Jul 2013 16:53:55 GMT

See attached example.

Mon, 22 Jul 2013 18:05:17 GMT

Hi Gysbert ,

Thanks for your reply ...indivudal clients seems to be correct... but 'Others' total does not seems to tie up .

Others totals should look like this

jagan — Mon, 22 Jul 2013 18:54:01 GMT

Hi,

PFA file for solution.

Regards,

Jagan.