logic

[#1]

Dear Community

i have following issue

that is

i have dimention name by ratiing

Rating

A

B

C1

C2

C3

D

NF

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

[IAMDV · Accepted solution]

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,

DV

www.QlikShare.com

[#3]

HAI

NICE SOLUTION

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

HERE SHOWING SOME NULLS

ANY SUGGESTIINS