Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Not applicable

listbox mini chart

hi,everybody.

i have a question for this,how can i do like that:

t.JPG.jpg

1 Solution

Accepted Solutions
Not applicable

Re: Re: Re: listbox mini chart

no worries. Have a list box based on SHOP and then add 2 expressions.

1st expression is simple. Sum(Amount)

2nd expression is Sum(Amount)/Max(Total Aggr(Sum(Amount),SHOP))

            Make the representation as Linear Guage

            Goto Gauge settings, delete Segment 2.

            Choose mode to "Fill to Value"

            Deselect "Show Scale"

Let me know if you have issues.

16 Replies
gupta_n8
Valued Contributor II

Re: listbox mini chart

you may write an expression in list box and define it as mini chart.

Then you can even customize your mini chart for bar, line , guage etc.

Not applicable

Re: listbox mini chart

Thank you very much

but when i try this ,it's like that:

捕获.JPG.jpg

MVP
MVP

Re: listbox mini chart

Hi,

Create two expressions in Expression tab and select 1 expression as Text in 'Representation' listbox and another as Linear Gauge.

Regards,

Jagan.

MVP
MVP

Re: listbox mini chart

Hi,

Can you attach sample file?

Regards,

jagan.

Not applicable

Re: Re: listbox mini chart

PFA.

Thanks,

Ram

Not applicable

Re: listbox mini chart

hi, jagan.

sorry ,i can't find where i can attach the file.

Data like that:

LOAD * INLINE [
    SHOP, BRAND, PLU, Amount
    S1, B1, P1, 5000.30
    S2, B1, P1, 6429.29
    S2, B3, P2, 3400.29
    S3, B2, P4, 7200.01
    S4, B2, P3, 2300.80
    S4, B4, P1, 6500.23
];

Not applicable

Re: listbox mini chart

Hi,

and expression is: sum({$<SHOP =>} Amount)

Not applicable

Re: Re: listbox mini chart

With your data.

Thanks,

Ram

Not applicable

Re: Re: Re: listbox mini chart

See the screenshot.

Community Browser