Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Bar graph representation .?

Hi All ,

How can I represent the below data 

clipboard_image_0.png

 

in graphical representation like below- 

clipboard_image_2.png

sample model attached.

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Re: Bar graph representation .?

I have checked your app, & that's why I asked you to create this Flag Dimension in back end (Load Script). This way you can check what values the flag holds & then correct your "If" statement accordingly until you get the required result. I can't try out this part on my end because I don't have the valid connections. Also,when using "If" I would recommend the range to be defined as follows :

if(CLAIMS_CAPTURED_MONTH_NAME =' '>' & $(12Month)'
and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] <=250000, 'Claims up to R250 000',if( CLAIMS_CAPTURED_MONTH_NAME =' '>' & $(12Month)'
and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] >250000 and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID]<500000,'Claims > R250k and < R500k',if( CLAIMS_CAPTURED_MONTH_NAME =' '>' & $(12Month)'
and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] >500000 and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID]<1000000,'Claims > R500k and < R1m',if( CLAIMS_CAPTURED_MONTH_NAME =' '>' & $(12Month)' and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] >1000000,'Claims > R1m'))))

Thanks & Regards 

Rohan S. Desai 

View solution in original post

9 Replies
Highlighted
Creator
Creator

Re: Bar graph representation .?

Hello,

Try taking "Claims by value band" field as a Dimension &  Sum of Motors & Sum of Non-Motors  as measure in  a normal Bar Graph. After that you can even personalize the presentation & colours as you wish in Appearance column in Bar Graph Properties.

Let me know if you have any queries.

Thanks & Regards.

Rohan S. Desai

Highlighted
Creator III
Creator III

Re: Bar graph representation .?

Hi Rohan ,

"Claims by value band"  are measures. I am unable to take them as dimension.

Will you please help them by implementing them in my sample model.

Thanks,

Suvechha

Highlighted
Creator
Creator

Re: Bar graph representation .?

Ok, Try creating Flags of these Value Bands using "If" statement & use the Set analysis expressions as conditions in the "If". Then you can call these flags as dimensions in your bar graph.

Thanks  & Regards 

Rohan S. Desai

Highlighted
Creator
Creator

Re: Bar graph representation .?

For example, 

if([Partner Grouping Name]='Personal & Commercial'
and CLAIMS_CAPTURED_MONTH_NAME =' '>' & $(12Month)'
and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] <=250000, 'Claims greater than 250000',if(....)) as flag,

 

Try this & use this flag as a dimension in the graph.

Let me know if you have any queries.

Thanks & Regards 

Rohan S. Desai

Highlighted
Creator III
Creator III

Re: Bar graph representation .?

Hi Rohan ,

I have defined the 

Flags in variable  see below image and used the variable in dimension. But my dimension is saying invalid dimension. Please kindly have a look on my sample model.

clipboard_image_0.png

Highlighted
Creator
Creator

Re: Bar graph representation .?

I have checked your app, & that's why I asked you to create this Flag Dimension in back end (Load Script). This way you can check what values the flag holds & then correct your "If" statement accordingly until you get the required result. I can't try out this part on my end because I don't have the valid connections. Also,when using "If" I would recommend the range to be defined as follows :

if(CLAIMS_CAPTURED_MONTH_NAME =' '>' & $(12Month)'
and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] <=250000, 'Claims up to R250 000',if( CLAIMS_CAPTURED_MONTH_NAME =' '>' & $(12Month)'
and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] >250000 and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID]<500000,'Claims > R250k and < R500k',if( CLAIMS_CAPTURED_MONTH_NAME =' '>' & $(12Month)'
and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] >500000 and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID]<1000000,'Claims > R500k and < R1m',if( CLAIMS_CAPTURED_MONTH_NAME =' '>' & $(12Month)' and [EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] >1000000,'Claims > R1m'))))

Thanks & Regards 

Rohan S. Desai 

View solution in original post

Highlighted
Creator III
Creator III

Re: Bar graph representation .?

Hi Rohan ,

I am getting a error -

The following error occurred:
Error in expression: ')' expected
 
but can't find the error -
 
My Script -
 
"FlagFields":
LOAD
CLAIMS_CAPTURED_MONTH_KEY,
if([EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] <=250000, 'Claims up to R250 000',
if([EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] >250000<500000,'Claims > R250k and < R500k',
if([EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] >500000<1000000,'Claims > R500k and < R1m',
if([EARLIEST_CLAIM_TOTAL_GROSS_CLAIMS_PAID] >1000000,'Claims > R1m') ) ) ) as FlagData
Resident
DWQMV_MONTH_CLAIM_CAPTURED;

left join (DWQMV_MONTH_CLAIM_CAPTURED)
Load
CLAIMS_CAPTURED_MONTH_KEY,
FlagData
Resident FlagFields;

drop Table FlagFields;
 
Please klindly have a look.
Highlighted
Creator
Creator

Re: Bar graph representation .?

Please correct the way you specify range in your "If" statement.

dashboard_sample.jpg

Thanks & Regards

Rohan S. Desai

Creator III
Creator III

Re: Bar graph representation .?

Thanks Rohan. It worked.

Please can you have a look on my below link question.

https://community.qlik.com/t5/New-to-Qlik-Sense/Y-axis-not-working-according-my-requirement-please-k...