topic Re: logic in QlikView

logic

Thu, 24 Jan 2013 11:19:59 GMT

Dear Community

i have following issue

that is

i have dimention name by ratiing

Rating

EQU

SO I WANT TO SHOW TOTAL C1+C2+C3 AMOUNT AS C REST OF ALL SAME

ANY IDEA RATING IS COMING FROM MASTER MASTER

Re: logic

IAMDV — Thu, 24 Jan 2013 11:30:51 GMT

Hi Ram,

You can achieve this in many ways. You can do it in the Script and UI. If you just wanted to show in UI/Chart then you need simple Calculated Dimension. Something like this...

=IF(Rating LIKE 'C*', 'C', Rating)

This uses the Wild Card Search with Like Operator.

Attaching the example for your reference.

Cheers,

www.QlikShare.com

Re: logic

Thu, 24 Jan 2013 11:40:02 GMT

HAI

NICE SOLUTION

AND ONE MORE I HAVE SOME EXCELS THERE IS NO NULL BUT AFTER DATA MODEL

HERE SHOWING SOME NULLS

ANY SUGGESTIINS