Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Different Charts in Straight table

I have a data source as attached.

I need to display the output as shown in the straight table.png image

I have used Budget in linear chart and status in traffic light chart.

My need is :

I have a month as one dimension which must show the value month wise in each column as shown in image.


1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Hi,

In that case you might have to write separate expression for each month.

refer the sample attached.

Br,

KC

Best Regards,
KC

View solution in original post

6 Replies
Highlighted
Master
Master

You can use pivot table and drag the dimension as cross table.

Else if  you want it to be in straight table means, you can check by doing a cross table load in script and transpose the month dimension as a work around.

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Highlighted
Creator II
Creator II

can you clear describe the steps

Highlighted
Master
Master

Do Check this app,

Color status.JPG

HirisH
“Aspire to Inspire before we Expire!”
Highlighted
Creator II
Creator II

But I need the status as one column not to be repeated as shown in above image

Highlighted
Master II
Master II

Hi,

In that case you might have to write separate expression for each month.

refer the sample attached.

Br,

KC

Best Regards,
KC

View solution in original post

Highlighted
Creator II
Creator II

I got it.

Thanks Jyothish.