Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mambi
Contributor III

chart calculation

Hi everyone,

from the table below i want to make a chart so for every country if the 'music' info exists the chart bar display 1 else 0

Country

Market

France

video games

France

music

France

books

France

tourisme

Spain

books

Spain

tourisme

Deutch

video games

Deutch

music

Deutch

books

Deutch

tourisme

Deutch

cars

Deutch

job

thanks

Tags (1)
3 Replies
Not applicable

Re: chart calculation

Please find the attached file

Re: chart calculation

Hi

PFA

michael_gardner
Contributor III

Re: chart calculation

You can easily make a Flag Field in the script.

IF(Market = 'music' , 1 , 0)  as _musicflag

Then you can use _musicflag as your dimension in the chart.

Community Browser